[Home] [Help]
APPS.CZ_IMP_MGR dependencies on DUAL
Line 79: WHERE TRUNC(started) < (SELECT TRUNC(SYSDATE) - p_days FROM DUAL);
75: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
76: l_run_id_tbl.DELETE;
77: SELECT run_id BULK COLLECT INTO l_run_id_tbl
78: FROM cz_xfr_run_infos
79: WHERE TRUNC(started) < (SELECT TRUNC(SYSDATE) - p_days FROM DUAL);
80: IF (l_run_id_tbl.COUNT > 0) THEN
81: delete_runs(l_run_id_tbl);
82: END IF;
83: DBMS_APPLICATION_INFO.SET_MODULE('','');