DBA Data[Home] [Help]

APPS.JAI_AR_VALIDATE_DATA_PKG dependencies on AR_VAT_TAX_ALL

Line 454: ar_vat_tax_all avtl

450: CURSOR cur_chk_non_il_taxes(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
451: IS
452: SELECT 1
453: FROM ra_customer_trx_lines_all rctl,
454: ar_vat_tax_all avtl
455: WHERE rctl.vat_tax_id = avtl.vat_tax_id
456: AND rctl.org_id = avtl.org_id
457: AND rctl.customer_trx_id = cp_customer_trx_id
458: AND avtl.tax_code <> jai_constants.tax_code_localization--'Localization' --Added by Bgowrava for Bug#5484865