DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on ZX_PRODUCT_OPTIONS

Line 497: FROM zx_product_options sp

493: CURSOR c_sysparam IS
494: SELECT sp.tax_classification_code,
495: NULL,
496: NULL
497: FROM zx_product_options sp
498: ,ar_vat_tax vt
499: WHERE sp.application_id = 222
500: AND sp.org_id = vt.org_id
501: AND sp.tax_classification_code = vt.tax_code

Line 523: ,zx_product_options sp

519: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
520: AND exists (select 1
521: from ar_vat_tax vt1
522: ,ar_vat_tax vt
523: ,zx_product_options sp
524: WHERE sp.tax_classification_code = vt.tax_code
525: AND sp.application_id = 222
526: AND sp.org_id = vt.org_id
527: AND vt.tax_type = 'TAX_GROUP'