APPS.CE_AUTO_BANK_MATCH dependencies on CE_MISC_TAX_CODE_V

Line 7559: FROM ce_misc_tax_code_v ar --ar_vat_tax ar

7555:
7556: IF (CE_AUTO_BANK_MATCH.csl_trx_type IN ('MISC_DEBIT','DEBIT','STOP')) THEN
7557: SELECT ar.vat_tax_id, ar.tax_rate
7558: INTO l_vat_tax_id, X_tax_rate
7559: FROM ce_misc_tax_code_v ar --ar_vat_tax ar
7560: WHERE ar.tax_code = y_dr_vat_tax_code
7561: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id)
7562: AND to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
7563: between to_char(ar.start_date,'YYYY/MM/DD')

Line 7569: FROM ce_misc_tax_code_v ar --ar_vat_tax ar

7565: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'));
7566: ELSE
7567: SELECT ar.vat_tax_id, ar.tax_rate
7568: INTO l_vat_tax_id, X_tax_rate
7569: FROM ce_misc_tax_code_v ar --ar_vat_tax ar
7570: WHERE tax_code = y_cr_vat_tax_code
7571: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id)
7572: AND to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
7573: between to_char(ar.start_date,'YYYY/MM/DD')