eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_OLD_PKG dependencies on DUAL

Line 1097: FROM DUAL;

1093:
1094: /* Commented by Aparajita on 07/07/2002 for bug # 2439034 as it was not being used.
1095: CURSOR for_invoice_num(invoice_num VARCHAR2) IS
1096: SELECT 'RTN/'|| invoice_num || '/' ||TO_CHAR(JAI_AP_TDS_INVOICE_NUM_S.CURRVAL)
1097: FROM DUAL;
1098: */
1099:
1100: Cursor get_prepay_dist_date is -- bug 3112711 kpvs
1101: select accounting_date

Line 1434: FROM dual;

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
1437: fetch get_prepay_dist_date into v_prepay_dist_date;
1438: close get_prepay_dist_date;

Line 1575: FROM dual;

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
1578: lv_description := 'CM FOR SUPPLIER FOR TDS DEDUCTED AFTER UNAPPLY '; --rchandan for bug#4428980
1579: lv_source := 'INDIA TDS'; --rchandan for bug#4428980

Line 1966: FROM DUAL;

1962:
1963: /* commented by Aparajita for bug 2364106 on 15-may-2002
1964: CURSOR for_invoice_num(invoice_num VARCHAR2) IS
1965: SELECT 'RTN/'|| invoice_num || '/' ||TO_CHAR(JAI_AP_TDS_INVOICE_NUM_S.CURRVAL)
1966: FROM DUAL;
1967: */
1968:
1969:
1970: CURSOR get_fun_det1(inv_id NUMBER) IS

Line 2651: FROM dual;

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;
2654: SELECT ap_invoices_interface_s.NEXTVAL
2655: INTO v_ap_invoices_interface_no

Line 2656: FROM dual;

2652:
2653: v_ap_invoices_interface_no := NULL;
2654: SELECT ap_invoices_interface_s.NEXTVAL
2655: INTO v_ap_invoices_interface_no
2656: FROM dual;
2657:
2658: Open get_prepay_dist_date; -- bug 3112711 kpvs
2659: fetch get_prepay_dist_date into v_prepay_dist_date;
2660: close get_prepay_dist_date;

Line 2813: FROM dual;

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;
2816:
2817: SELECT ap_invoices_interface_s.NEXTVAL

Line 2819: FROM dual;

2815: v_ap_invoices_interface_no := NULL;
2816:
2817: SELECT ap_invoices_interface_s.NEXTVAL
2818: INTO v_ap_invoices_interface_no
2819: FROM dual;
2820:
2821: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
2822: v_stage:=9;
2823:

Line 3111: FROM dual;

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;
3114: SELECT ap_invoices_interface_s.NEXTVAL
3115: INTO v_ap_invoices_interface_no

Line 3116: FROM dual;

3112:
3113: v_ap_invoices_interface_no := NULL;
3114: SELECT ap_invoices_interface_s.NEXTVAL
3115: INTO v_ap_invoices_interface_no
3116: FROM dual;
3117:
3118: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 3:CREDIT NOTE FOR TDS AUTHORITY FOR APPLIED AMOUNT OF TAX');
3119: v_stage:=14;
3120:

Line 3255: FROM dual;

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;
3258:
3259: SELECT ap_invoices_interface_s.NEXTVAL

Line 3261: FROM dual;

3257: v_ap_invoices_interface_no := NULL;
3258:
3259: SELECT ap_invoices_interface_s.NEXTVAL
3260: INTO v_ap_invoices_interface_no
3261: FROM dual;
3262:
3263: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
3264: v_stage:=15;
3265: