DBA Data[Home] [Help]

APPS.EDW_SEC_PKG dependencies on DUAL

Line 855: select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;

851: goto last2;
852: end if;
853: --
854: -- This is to take care of pl/sql bug with sys_context
855: select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;
856:
857: If d_predicate is null then
858: d_predicate := x_fk_col_name ||
859: ' in ('||

Line 911: select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;

907: goto last;
908: end if;
909: --
910: -- This is to take care of pl/sql bug with sys_context
911: select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;
912:
913: If d_predicate is null then
914: d_predicate := x_fk_col_name ||
915: ' in ('||

Line 1127: select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;

1123: goto last;
1124: end if;
1125: --
1126: -- This is to take care of pl/sql bug with sys_context
1127: select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;
1128:
1129: -- ASSUMPTION : Only one reference (person_fk_key) needs to be secured.
1130:
1131: -- If d_predicate is null then