When QP: Security Control turned on why the policy applied to database with date 04-Aug-2006
Hi,
declare
s varchar2(10000);
begin
s:= 'e';
s:=qp_security.qp_vl_sec('APPS','QP_POLICY_LIST_HEADERS_VL');
dbms_output.put_line('s: ' ||s);
end;
after i turned on the QP: Security Control and then i run the above query, we can see the dbms output as
s: ((list_type_code = 'AGR' ) OR (list_type_code = 'PRL' ) OR (list_type_code in ('SLT','PRO','DLT','DEL','CHARGES') and nvl(END_DATE_ACTIVE, sysdate) > '04-Aug-2006'))
why it has condition greater than '04-Aug-2006'? Is the date hard coded or populated from some where? if populated from some where then where is it coming from?