APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on DUAL

Line 1402: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;

1398: from jai_ap_tds_thhold_trxs
1399: where threshold_trx_id = cp_threshold_trx_id;
1400:
1401: cursor c_get_form16_hdr_id is
1402: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;
1403: /*bduvarag for Bug#5647725*/
1404: CURSOR cur_get_tds_section IS
1405: SELECT decode(p_section_type,'TDS_SECTION','TDS','WCT_SECTION','WCT','ESSI_SECTION','ESI')
1406: FROM dual;

Line 1406: FROM dual;

1402: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;
1403: /*bduvarag for Bug#5647725*/
1404: CURSOR cur_get_tds_section IS
1405: SELECT decode(p_section_type,'TDS_SECTION','TDS','WCT_SECTION','WCT','ESSI_SECTION','ESI')
1406: FROM dual;
1407:
1408: /*Bug 10621438*/
1409: CURSOR c_get_cert_date(cp_f16_hdr_id number) IS
1410: SELECT max(invoice_date)