APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_CMN_TAXES_ALL

Line 200: ,jai_cmn_taxes_all jcta

196: ) IS
197: SELECT jcta.tax_rate
198: ,jcta.tax_id
199: FROM jai_cmn_tax_ctg_lines jctcl
200: ,jai_cmn_taxes_all jcta
201: WHERE jctcl.tax_id = jcta.tax_id
202: AND jctcl.tax_category_id = p_tax_category_id
203: AND jcta.section_type = p_section_type
204: ;

Line 603: ,jai_cmn_taxes_all jcta

599: And jatr.tax_category_id is not null
600: And not exists ( --make sure under surcharge slab
601: Select 1
602: From jai_cmn_tax_ctg_lines jctcl
603: ,jai_cmn_taxes_all jcta
604: ,jai_ap_tds_repo_lines jatrl
605: Where jctcl.tax_id = jcta.tax_id
606: And jctcl.tax_category_id = jatr.tax_category_id
607: AND jatrl.invoice_id = jatr.invoice_id

Line 780: ,Jai_cmn_taxes_all jcta

776:
777: cursor c_get_tax_from_category(p_tax_category_id in NUMBER) is
778: Select jctcl.tax_id
779: From jai_cmn_tax_ctg_lines jctcl
780: ,Jai_cmn_taxes_all jcta
781: Where jcta.tax_id = jctcl.tax_id
782: AND jctcl.tax_category_id = p_tax_category_id
783: AND jcta.tax_type in (G_TDS, G_TDS_EDUCATION_CESS, G_TDS_SH_EDU_CESS, G_TDS_SURCHARGE ); --exclude WCT/ESSI
784:

Line 786: CURSOR c_tax_rates(p_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE)

782: AND jctcl.tax_category_id = p_tax_category_id
783: AND jcta.tax_type in (G_TDS, G_TDS_EDUCATION_CESS, G_TDS_SH_EDU_CESS, G_TDS_SURCHARGE ); --exclude WCT/ESSI
784:
785:
786: CURSOR c_tax_rates(p_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE)
787: IS
788: SELECT
789: NVL(tax_rate,0) tax_rate,
790: (NVL(tax_rate,0) - (NVL(surcharge_rate,0) + NVL(cess_rate,0) + NVL(sh_cess_rate,0))) tds_rate,

Line 795: JAI_CMN_TAXES_ALL jtc

791: NVL(surcharge_rate,0) surcharge_rate,
792: NVL(cess_rate,0) cess_rate,
793: NVL(sh_cess_rate,0) sh_cess_rate
794: FROM
795: JAI_CMN_TAXES_ALL jtc
796: WHERE
797: tax_id = p_tax_id ;
798:
799: --Get transaction information by TDS invoice_id

Line 1440: ,JAI_CMN_TAXES_ALL jitc

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
1443: AND jatit.threshold_grp_id IS NOT NULL
1444: AND jatit.threshold_grp_id = r_thhold_grp_rec.threshold_grp_id

Line 1572: ,JAI_CMN_TAXES_ALL jitc

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
1575: AND jatit.threshold_grp_id IS NOT NULL
1576: AND jatit.threshold_grp_id = r_thhold_grp_rec.threshold_grp_id

Line 1797: JAI_CMN_TAXES_ALL jitc,

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
1800: AND jatit.threshold_grp_id IS NOT NULL
1801: AND aia.cancelled_date IS NULL

Line 1929: from jai_cmn_taxes_all a

1925: ,a.tax_id TAX_ID
1926: ,base_invoices.invoice_amount BASE_TAX_AMOUNT
1927: ,G_Y REQUIRED_FOR_ETDS
1928: ,G_Y MIGRATED
1929: from jai_cmn_taxes_all a
1930: , ap_invoices_all base_invoices
1931: , po_vendor_sites_all povs
1932: , ap_invoice_distributions_all aida
1933: , jai_ap_tds_vendor_hdrs jte

Line 2045: FROM JAI_CMN_TAXES_ALL jcta

2041: FOR r_c_get_taxes_info IN ( SELECT jcta.tax_id
2042: ,jcta.tax_name
2043: ,jcta.tax_rate
2044: ,jcta.tax_type
2045: FROM JAI_CMN_TAXES_ALL jcta
2046: ,JAI_CMN_TAX_CTG_LINES jctcl
2047: WHERE jctcl.tax_category_id = ln_tax_category_id
2048: AND jcta.tax_id = jctcl.tax_id
2049: AND jcta.tax_type IN (G_TDS, G_TDS_EDUCATION_CESS, G_TDS_EDUCATION_CESS, G_TDS_SURCHARGE)

Line 2108: FROM jai_cmn_taxes_all jcta

2104: ) IS
2105: SELECT jcta.tax_id
2106: ,jcta.tax_type
2107: ,jcta.tax_name
2108: FROM jai_cmn_taxes_all jcta
2109: WHERE jcta.tax_type = p_tax_type
2110: AND jcta.tax_id = p_tax_id
2111: ;
2112: