DBA Data[Home] [Help]

APPS.DDR_ETL_UTIL_PKG dependencies on DUAL

Line 17: v_owner_sql := 'select user from dual';

13: IS
14: v_owner_sql VARCHAR2(1000);
15: v_user VARCHAR2(100);
16: BEGIN
17: v_owner_sql := 'select user from dual';
18: EXECUTE IMMEDIATE v_owner_sql
19: INTO v_user;
20:
21: g_owner_name_real := v_user;

Line 901: SELECT ddr_u_mv_rfrsh_seq.nextval INTO v_seq FROM DUAL;

897: ) IS
898: v_seq NUMBER;
899: BEGIN
900:
901: SELECT ddr_u_mv_rfrsh_seq.nextval INTO v_seq FROM DUAL;
902: INSERT INTO ddr_u_mv_rfrsh_log(refresh_job_id
903: ,refresh_sequence
904: ,mv_name
905: ,refresh_method

Line 963: SELECT ddr_u_mv_rfrsh_seq.nextval INTO v_seq FROM DUAL;

959: ) IS
960: v_seq NUMBER;
961: BEGIN
962:
963: SELECT ddr_u_mv_rfrsh_seq.nextval INTO v_seq FROM DUAL;
964: INSERT INTO ddr_u_mv_rfrsh_log(refresh_job_id
965: ,refresh_sequence
966: ,mv_name
967: ,refresh_method