APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 873: FROM ap_invoice_payments_all PAY

869:
870: CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
871: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
872: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number
873: FROM ap_invoice_payments_all PAY
874: , ap_checks_all APC
875: , JAI_AP_TDS_PAYMENTS JATP
876: WHERE PAY.invoice_id = p_invoice_id
877: AND PAY.check_id = APC.check_id

Line 1678: ,ap_invoice_payments_all aipa

1674: ,jatp.check_deposit_date
1675: ,jatp.bsr_code
1676: ,jatp.payment_reference_id
1677: FROM jai_ap_tds_payments jatp
1678: ,ap_invoice_payments_all aipa
1679: WHERE jatp.check_id = aipa.check_id
1680: AND aipa.invoice_id = jatr.invoice_id
1681: )
1682: WHERE jatr.migrated= 'Y'

Line 1686: ,ap_invoice_payments_all aipa

1682: WHERE jatr.migrated= 'Y'
1683: AND EXISTS(
1684: SELECT 1
1685: FROM jai_ap_tds_payments jatp
1686: ,ap_invoice_payments_all aipa
1687: WHERE jatp.check_id = aipa.check_id
1688: AND aipa.invoice_id = jatr.invoice_id
1689: );
1690: