APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_AP_TDS_PAYMENTS

Line 875: , JAI_AP_TDS_PAYMENTS JATP

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
878: AND APC.check_id = JATP.check_id
879: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 1677: FROM jai_ap_tds_payments jatp

1673: ,jatp.check_date
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: )

Line 1685: FROM jai_ap_tds_payments jatp

1681: )
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: );