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_ETDS_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 287: FROM ap_invoice_payments_all PAY, ap_checks_all APC

283: -- p_invoice_id contains tds_invoice_id incase if tds amount is directly paid to TDS Authorities using a c
284: -- p_invoice_id contains PREPAYMENT invoice_id to TDS Auth., if TDS invoice is applied to PREPAYMENT invo
285: /*CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
286: SELECT pay.check_id, apc.bank_account_id, apc.attribute3 challan_num, apc.attribute1 challan_date -- p
287: FROM ap_invoice_payments_all PAY, ap_checks_all APC
288: WHERE PAY.invoice_id = p_invoice_id
289: AND PAY.check_id = APC.check_id
290: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);--rchandan for bug#4428980
291:

Line 294: FROM ap_invoice_payments_all PAY, ap_checks_all APC

290: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);--rchandan for bug#4428980
291:
292: CURSOR c_base_payment_check_id(p_invoice_id IN NUMBER) IS
293: SELECT pay.check_id, apc.bank_account_id, check_date
294: FROM ap_invoice_payments_all PAY, ap_checks_all APC
295: WHERE PAY.invoice_id = p_invoice_id
296: AND PAY.check_id = APC.check_id
297: AND APC.status_lookup_code NOT IN (lv_voided, lv_stop_init);--rchandan for bug#4428980*/
298:

Line 327: FROM ap_invoice_payments_all PAY, ap_checks_v APC, JAI_AP_TDS_PAYMENTS JATP

323: /*Modified the cursor c_tds_payment_check_id by JMEENA for bug#4600778 to select the bsr_code from JAI_AP_TDS_PAYMENTS table */
324: CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
325: SELECT pay.check_id, apc.current_bank_account_name, JATP.Challan_no challan_num,
326: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code
327: FROM ap_invoice_payments_all PAY, ap_checks_v APC, JAI_AP_TDS_PAYMENTS JATP
328: WHERE PAY.invoice_id = p_invoice_id
329: AND PAY.check_id = APC.check_id
330: AND APC.check_id = JATP.check_id
331: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 335: FROM ap_invoice_payments_all PAY, ap_checks_v APC

331: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);
332:
333: CURSOR c_base_payment_check_id(p_invoice_id IN NUMBER) IS
334: SELECT pay.check_id, apc.current_bank_account_name, check_date
335: FROM ap_invoice_payments_all PAY, ap_checks_v APC
336: WHERE PAY.invoice_id = p_invoice_id
337: AND PAY.check_id = APC.check_id
338: AND APC.status_lookup_code NOT IN (lv_voided, lv_stop_init);
339: