APPS.ZX_PTP_IMPORT dependencies on ZX_STATUS_B

Line 4604: FROM zx_status_b zsvl,

4600: WHERE (( tax_status_code IS NOT NULL
4601: AND NOT EXISTS
4602: (
4603: SELECT 1
4604: FROM zx_status_b zsvl,
4605: zx_subscription_details zsd
4606: WHERE zsvl.allow_exemptions_flag = 'Y'
4607: AND zsd.tax_regime_code = zsvl.tax_regime_code
4608: AND zsd.parent_first_pty_org_id = zsvl.content_owner_id

Line 4613: FROM zx_status_b b

4609: AND (NVL(zsd.view_options_code,'NONE') IN ('NONE', 'VFC') OR
4610: (NVL(zsd.view_options_code,'VFR') = 'VFR'
4611: AND NOT EXISTS
4612: (SELECT 1
4613: FROM zx_status_b b
4614: WHERE b.tax_regime_code = zsvl.tax_regime_code
4615: AND b.tax = zsvl.tax
4616: AND b.tax_status_code = zsvl.tax_status_code
4617: AND b.content_owner_id = zsd.first_pty_org_id

Line 4642: FROM zx_status_b b

4638: AND (NVL(zsd.view_options_code,'NONE') IN ('NONE', 'VFC') OR
4639: (NVL(zsd.view_options_code,'VFR') = 'VFR'
4640: AND NOT EXISTS
4641: (SELECT 1
4642: FROM zx_status_b b
4643: WHERE b.tax_regime_code = zsvl.tax_regime_code
4644: AND b.tax = zsvl.tax
4645: AND b.tax_status_code = zsvl.tax_status_code
4646: AND b.content_owner_id = zsd.first_pty_org_id

Line 4681: FROM zx_status_b b

4677: AND (NVL(zsd.view_options_code,'NONE') IN ('NONE', 'VFC') OR
4678: (NVL(zsd.view_options_code,'VFR') = 'VFR'
4679: AND NOT EXISTS
4680: (SELECT 1
4681: FROM zx_status_b b
4682: WHERE b.tax_regime_code = zsvl.tax_regime_code
4683: AND b.tax = zsvl.tax
4684: AND b.tax_status_code = zsvl.tax_status_code
4685: AND b.content_owner_id = zsd.first_pty_org_id