APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_CMN_TAX_CTGS_ALL

Line 89: FROM jai_cmn_tax_ctgs_all jctc

85: IS
86: --
87: CURSOR c_get_category(pn_tax_id NUMBER) is
88: SELECT jctc.tax_category_id
89: FROM jai_cmn_tax_ctgs_all jctc
90: WHERE jctc.tax_category_desc like '% New TDS migrated from: ' || p_tax_id || '%'
91: ;
92: ln_tax_categeory_id NUMBER;
93: l_api_name CONSTANT VARCHAR2(50) := 'map_tds_tax_to_ctg()';

Line 173: ,jai_cmn_tax_ctgs_all jctca

169: --,NVL(REGEXP_SUBSTR(jattt.invoice_to_tds_authority_num, '(WCT|TDS|ESSI)-\w+-\d+$',1,1,'i',1), G_TDS) withhold_tax_type
170: ,jctca.effective_tds_rate
171: FROM jai_ap_tds_thhold_trxs jattt
172: ,ap_invoices_all tds_inv
173: ,jai_cmn_tax_ctgs_all jctca
174: WHERE jattt.invoice_to_tds_authority_id = tds_inv.invoice_id
175: AND jattt.tax_category_id = jctca.tax_category_id(+)
176: AND jattt.invoice_to_tds_authority_id = p_tds_invoice_id
177: ;