DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_STATUS_VL

Line 4633: FROM zx_status_vl zsvl,

4629: AND tax_status_name IS NOT NULL
4630: AND NOT EXISTS
4631: (
4632: SELECT 1
4633: FROM zx_status_vl zsvl,
4634: zx_subscription_details zsd
4635: WHERE zsvl.allow_exemptions_flag = 'Y'
4636: AND zsd.tax_regime_code = zsvl.tax_regime_code
4637: AND zsd.parent_first_pty_org_id = zsvl.content_owner_id

Line 4672: FROM zx_status_vl zsvl,

4668: -- value to id conversion for tax_status_code
4669: UPDATE zx_exemptions_int exe_int
4670: SET tax_status_code = (
4671: SELECT zsvl.TAX_STATUS_CODE
4672: FROM zx_status_vl zsvl,
4673: zx_subscription_details zsd
4674: WHERE zsvl.allow_exemptions_flag = 'y'
4675: AND zsd.tax_regime_code = zsvl.tax_regime_code
4676: AND zsd.parent_first_pty_org_id = zsvl.content_owner_id