APPS.JAI_AP_TDS_OLD_PKG dependencies on JAI_AP_TDS_THHOLD_TRXS_S1

Line 1432: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval --JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676

1428: CLOSE for_distribution_insertion;
1429:
1430:
1431: -- added by Aparajita to remove references to currval
1432: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval --JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676
1433: INTO v_tds_inv_run_num
1434: FROM dual;
1435:
1436: Open get_prepay_dist_date; -- bug 3112711 kpvs

Line 1573: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval --JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676

1569: FETCH for_distribution_insertion INTO for_dist_rec;
1570: CLOSE for_distribution_insertion;
1571:
1572:
1573: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval --JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676
1574: INTO v_sup_cm_run_num
1575: FROM dual;
1576: lv_lookup_type_code:= 'CREDIT';
1577: lv_invoice_num := for_std_inv_rec.invoice_num||'CM/'||TO_CHAR(v_sup_cm_run_num); --rchandan for bug#4428980

Line 2427: Sequnece jai_ap_tds_invoice_num_s is renamed to JAI_AP_TDS_THHOLD_TRXS_S1

2423: be populated in the attribute columns of ap_invoice_distributions_all table
2424: instead these will be populated in the global attribute columns. So the code changes are
2425: made accordingly.
2426: 22. 14-Jul-2005 rchandan for bug#4487676.File version 117.2
2427: Sequnece jai_ap_tds_invoice_num_s is renamed to JAI_AP_TDS_THHOLD_TRXS_S1
2428:
2429:
2430: ----------------------------------------------------------------------------------------------------------------------*/
2431: /* Ramananda for File.Sql.35*/

Line 2649: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676

2645: CLOSE get_exchange_rate_base_inv;
2646: --end 03-Jan-2002
2647:
2648: v_ja_ap_invoices_interface_no := NULL;
2649: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676
2650: INTO v_ja_ap_invoices_interface_no
2651: FROM dual;
2652:
2653: v_ap_invoices_interface_no := NULL;

Line 2811: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676

2807: CLOSE for_distribution_insertion;
2808:
2809: v_ja_ap_invoices_interface_no := NULL;
2810:
2811: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676
2812: INTO v_ja_ap_invoices_interface_no
2813: FROM dual;
2814:
2815: v_ap_invoices_interface_no := NULL;

Line 3109: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676

3105: CLOSE for_distribution_insertion ;
3106:
3107: v_ja_ap_invoices_interface_no := NULL;
3108:
3109: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676
3110: INTO v_ja_ap_invoices_interface_no
3111: FROM dual;
3112:
3113: v_ap_invoices_interface_no := NULL;

Line 3253: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676

3249: CLOSE for_distribution_insertion;
3250:
3251: v_ja_ap_invoices_interface_no := NULL;
3252:
3253: SELECT JAI_AP_TDS_THHOLD_TRXS_S1.nextval--JAI_AP_TDS_INVOICE_NUM_S.NEXTVAL changed by rchandan for bug#4487676
3254: INTO v_ja_ap_invoices_interface_no
3255: FROM dual;
3256:
3257: v_ap_invoices_interface_no := NULL;