DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on ZX_PRODUCT_OPTIONS

Line 502: FROM zx_product_options sp

498: CURSOR c_sysparam IS
499: SELECT sp.tax_classification_code,
500: NULL,
501: NULL
502: FROM zx_product_options sp
503: ,ar_vat_tax vt
504: WHERE sp.application_id = 222
505: AND sp.org_id = vt.org_id
506: AND sp.tax_classification_code = vt.tax_code

Line 528: ,zx_product_options sp

524: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
525: AND exists (select 1
526: from ar_vat_tax vt1
527: ,ar_vat_tax vt
528: ,zx_product_options sp
529: WHERE sp.tax_classification_code = vt.tax_code
530: AND sp.application_id = 222
531: AND sp.org_id = vt.org_id
532: AND vt.tax_type = 'TAX_GROUP'