APPS.ZX_VALIDATE_API_PKG dependencies on ZX_STATUS_VL

Line 1177: AND NOT EXISTS ( SELECT 1 FROM zx_status_vl b

1173: )
1174: )
1175: AND (NVL(sd_status.view_options_code,'NONE') in ('NONE', 'VFC')
1176: OR ( NVL(sd_status.view_options_code,'VFR') = 'VFR'
1177: AND NOT EXISTS ( SELECT 1 FROM zx_status_vl b
1178: WHERE b.tax_regime_code = status.tax_regime_code
1179: AND b.tax = status.tax
1180: AND b.tax_status_code = status.tax_status_code
1181: AND b.content_owner_id = sd_status.first_pty_org_id

Line 2185: FROM zx_status_vl b

2181: NVL(sd_status.view_options_code,'VFR') = 'VFR'
2182: AND not exists
2183: (
2184: SELECT 1
2185: FROM zx_status_vl b
2186: WHERE b.tax_regime_code = status.tax_regime_code
2187: AND b.tax = status.tax
2188: AND b.tax_status_code = status.tax_status_code
2189: AND b.content_owner_id = sd_status.first_pty_org_id

Line 5598: FROM zx_status_vl b

5594: NVL(sd_status.view_options_code,'VFR') = 'VFR'
5595: AND not exists
5596: (
5597: SELECT 1
5598: FROM zx_status_vl b
5599: WHERE b.tax_regime_code = status.tax_regime_code
5600: AND b.tax = status.tax
5601: AND b.tax_status_code = status.tax_status_code
5602: AND b.content_owner_id = sd_status.first_pty_org_id

Line 7595: FROM zx_status_vl b

7591: OR (
7592: NVL(sd_status.view_options_code,'VFR') = 'VFR'
7593: AND not exists (
7594: SELECT 1
7595: FROM zx_status_vl b
7596: WHERE b.tax_regime_code = status.tax_regime_code
7597: AND b.tax = status.tax
7598: AND b.tax_status_code = status.tax_status_code
7599: AND b.content_owner_id = sd_status.first_pty_org_id