DBA Data[Home] [Help]

APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_AP_TDS_INV_TAXES

Line 407: -- amount should derive from jai_ap_tds_inv_taxes, as we need change amount to INR currency

403:
404: /* @TODO
405: If BASE_TAX_AMOUNT is null then
406: --no TDS invoice created, derive base tax amount from current source invoice
407: -- amount should derive from jai_ap_tds_inv_taxes, as we need change amount to INR currency
408: -- by pn_source_invoice_id, tds_section_code, threshold_grp_id
409: BASE_TAX_AMOUNT <--- source invoice amount.
410: End if;*/
411: IF pn_invoice_id IN (-9999, -9997) THEN

Line 1438: ,jai_ap_tds_inv_taxes jatit

1434: ,fnd_global.login_id
1435: ,fnd_global.user_id
1436: FROM ap_invoices_all aia
1437: ,ap_invoice_distributions_all aida
1438: ,jai_ap_tds_inv_taxes jatit
1439: ,JAI_AP_TDS_VENDOR_HDRS jte
1440: ,JAI_CMN_TAXES_ALL jitc
1441: ,JAI_RGM_ORG_REGNS_V jror
1442: WHERE aia.invoice_id = jatit.invoice_id

Line 1570: ,jai_ap_tds_inv_taxes jatit

1566: ,fnd_global.login_id
1567: ,fnd_global.user_id
1568: FROM ap_invoices_all aia
1569: ,ap_invoice_distributions_all aida
1570: ,jai_ap_tds_inv_taxes jatit
1571: ,JAI_AP_TDS_VENDOR_HDRS jte
1572: ,JAI_CMN_TAXES_ALL jitc
1573: ,JAI_RGM_ORG_REGNS_V jror
1574: WHERE aia.invoice_id = jatit.invoice_id

Line 1795: jai_ap_tds_inv_taxes jatit,

1791: ,G_Y REQUIRED_FOR_ETDS
1792: ,G_Y MIGRATED
1793: FROM ap_invoices_all aia,
1794: ap_invoice_distributions_all aida,
1795: jai_ap_tds_inv_taxes jatit,
1796: JAI_AP_TDS_VENDOR_HDRS jte,
1797: JAI_CMN_TAXES_ALL jitc,
1798: JAI_RGM_ORG_REGNS_V jror
1799: WHERE aia.invoice_id = jatit.invoice_id