APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on DUAL

Line 1386: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;

1382: from jai_ap_tds_thhold_trxs
1383: where threshold_trx_id = cp_threshold_trx_id;
1384:
1385: cursor c_get_form16_hdr_id is
1386: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;
1387: /*bduvarag for Bug#5647725*/
1388: CURSOR cur_get_tds_section IS
1389: SELECT decode(p_section_type,'TDS_SECTION','TDS','WCT_SECTION','WCT','ESSI_SECTION','ESI')
1390: FROM dual;

Line 1390: FROM dual;

1386: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;
1387: /*bduvarag for Bug#5647725*/
1388: CURSOR cur_get_tds_section IS
1389: SELECT decode(p_section_type,'TDS_SECTION','TDS','WCT_SECTION','WCT','ESSI_SECTION','ESI')
1390: FROM dual;
1391:
1392:
1393: ln_cert_line_num NUMBER(15);
1394: ln_prev_parent_invoice_id ap_invoices_all.invoice_id%TYPE;