APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_PAYMENTS

Line 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 */

319: apc.check_id = jatp.check_id AND
320: jatp.check_id = cp_check_id;*/
321:
322: /*added by csahoo for bug # 6158875, START*/
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

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 346: FROM AP_CHECKS_V ACV, JAI_AP_TDS_PAYMENTS JATP

342: SELECT ACV.CURRENT_BANK_ACCOUNT_NAME ,
343: JATP.Challan_no challan_num,
344: JATP.check_deposit_date challan_date,
345: JATP.check_number
346: FROM AP_CHECKS_V ACV, JAI_AP_TDS_PAYMENTS JATP
347: WHERE ACV.check_id = JATP.check_id
348: AND jatp.check_id = cp_check_id
349: -- Bug 5975168. Added by csahoo
350: AND ACV.status_lookup_code NOT IN