APPS.CE_AUTO_BANK_MATCH dependencies on CE_MISC_TAX_CODE_V

Line 7335: FROM ce_misc_tax_code_v ar --ar_vat_tax ar

7331:
7332: IF (CE_AUTO_BANK_MATCH.csl_trx_type IN ('MISC_DEBIT','DEBIT','STOP')) THEN
7333: SELECT ar.vat_tax_id, ar.tax_rate
7334: INTO l_vat_tax_id, X_tax_rate
7335: FROM ce_misc_tax_code_v ar --ar_vat_tax ar
7336: WHERE ar.tax_code = y_dr_vat_tax_code
7337: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id)
7338: AND to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
7339: between to_char(ar.start_date,'YYYY/MM/DD')

Line 7345: FROM ce_misc_tax_code_v ar --ar_vat_tax ar

7341: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'));
7342: ELSE
7343: SELECT ar.vat_tax_id, ar.tax_rate
7344: INTO l_vat_tax_id, X_tax_rate
7345: FROM ce_misc_tax_code_v ar --ar_vat_tax ar
7346: WHERE tax_code = y_cr_vat_tax_code
7347: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id)
7348: AND to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
7349: between to_char(ar.start_date,'YYYY/MM/DD')