APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on DUAL

Line 2280: into g_selection_process_id from dual;

2276: END IF;
2277:
2278: if g_selection_process_id is null then
2279: select JG_ZZ_VAT_REP_STATUS_S1.NEXTVAL
2280: into g_selection_process_id from dual;
2281: end if;
2282:
2283:
2284: FORALL i IN 1 .. l_count

Line 3461: select 'jg_zz_vat' || to_char(sysdate,'ddmmyyyy_hhmiss') from dual ;

3457: FROM jg_zz_vat_trx_gt
3458: WHERE jg_info_n9 is null; /* final_reporting_id */
3459:
3460: CURSOR c_get_outfile IS
3461: select 'jg_zz_vat' || to_char(sysdate,'ddmmyyyy_hhmiss') from dual ;
3462:
3463: TYPE IdTab IS TABLE OF jg_zz_vat_trx_gt.jg_info_n1%TYPE;
3464: IdList IdTab ;
3465: