APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on DUAL

Line 2176: into g_selection_process_id from dual;

2172: END IF;
2173:
2174: if g_selection_process_id is null then
2175: select JG_ZZ_VAT_REP_STATUS_S1.NEXTVAL
2176: into g_selection_process_id from dual;
2177: end if;
2178:
2179:
2180: FORALL i IN 1 .. l_count

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

3276: FROM jg_zz_vat_trx_gt
3277: WHERE jg_info_n9 is null; /* final_reporting_id */
3278:
3279: CURSOR c_get_outfile IS
3280: select 'jg_zz_vat' || to_char(sysdate,'ddmmyyyy_hhmiss') from dual ;
3281:
3282: TYPE IdTab IS TABLE OF jg_zz_vat_trx_gt.jg_info_n1%TYPE;
3283: IdList IdTab ;
3284: