APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_TRXS_S

Line 5914: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676

5910: from gl_sets_of_books
5911: where set_of_books_id = cp_set_of_books_id;
5912:
5913: cursor c_get_ja_in_ap_inv_id is
5914: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676
5915: from dual;
5916:
5917: cursor c_ap_payment_schedules_all(p_invoice_id number) is
5918: select payment_priority

Line 6691: jai_ap_tds_thhold_trxs_s.nextval ,

6687: ,tds_section_code --Added by Chong for bug#16414088 20130313
6688: )
6689: values
6690: (
6691: jai_ap_tds_thhold_trxs_s.nextval ,
6692: pn_invoice_id ,
6693: pn_invoice_line_number ,
6694: pn_invoice_distribution_id ,
6695: pn_threshold_grp_id ,

Line 6833: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676

6829: from gl_sets_of_books
6830: where set_of_books_id = cp_set_of_books_id;
6831:
6832: cursor c_get_ja_in_ap_inv_id is
6833: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676
6834: from dual;
6835:
6836: cursor c_ap_payment_schedules_all(p_invoice_id number) is
6837: select payment_priority

Line 7895: jai_ap_tds_thhold_trxs_s.nextval ,

7891: ,TDS_SECTION_CODE --Add by zhiwei hou on 20120111
7892: )
7893: values
7894: (
7895: jai_ap_tds_thhold_trxs_s.nextval ,
7896: pn_invoice_id ,
7897: pn_invoice_line_number ,
7898: pn_invoice_distribution_id ,
7899: pn_threshold_grp_id ,

Line 8657: jai_ap_tds_thhold_trxs_s.nextval ,

8653: last_update_login
8654: )
8655: values
8656: (
8657: jai_ap_tds_thhold_trxs_s.nextval ,
8658: p_invoice_id ,
8659: p_tds_event ,
8660: p_tax_id ,
8661: p_tax_rate ,

Line 10362: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676

10358: from gl_sets_of_books
10359: where set_of_books_id = cp_set_of_books_id;
10360:
10361: cursor c_get_ja_in_ap_inv_id is
10362: select to_char(JAI_AP_TDS_THHOLD_TRXS_S1.nextval)--to_char(JAI_AP_TDS_INVOICE_NUM_S.nextval)commented by rchandan for bug#4487676
10363: from dual;
10364:
10365: cursor c_ap_payment_schedules_all(p_invoice_id number) is
10366: select payment_priority

Line 11072: jai_ap_tds_thhold_trxs_s.nextval ,

11068: TDS_SECTION_CODE
11069: )
11070: values
11071: (
11072: jai_ap_tds_thhold_trxs_s.nextval ,
11073: pn_invoice_id ,
11074: NULL ,
11075: NULL ,
11076: pn_threshold_grp_id ,