APPS.ZX_VALIDATE_API_PKG dependencies on ZX_STATUS_VL

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

864: )
865: )
866: AND (NVL(sd_status.view_options_code,'NONE') in ('NONE', 'VFC') OR
867: (NVL(sd_status.view_options_code,'VFR') = 'VFR'
868: AND NOT EXISTS ( SELECT 1 FROM zx_status_vl b
869: WHERE b.tax_regime_code = status.tax_regime_code
870: AND b.tax = status.tax
871: AND b.tax_status_code = status.tax_status_code
872: AND b.content_owner_id = sd_status.first_pty_org_id

Line 1869: FROM zx_status_vl b

1865: AND not exists
1866: (
1867: SELECT
1868: 1
1869: FROM zx_status_vl b
1870: WHERE b.tax_regime_code = status.tax_regime_code
1871: AND b.tax = status.tax
1872: AND b.tax_status_code = status.tax_status_code
1873: AND b.content_owner_id = sd_status.first_pty_org_id

Line 5593: FROM zx_status_vl b

5589: AND not exists
5590: (
5591: SELECT
5592: 1
5593: FROM zx_status_vl b
5594: WHERE b.tax_regime_code = status.tax_regime_code
5595: AND b.tax = status.tax
5596: AND b.tax_status_code = status.tax_status_code
5597: AND b.content_owner_id = sd_status.first_pty_org_id

Line 5878: FROM zx_status_vl b

5874: AND not exists
5875: (
5876: SELECT
5877: 1
5878: FROM zx_status_vl b
5879: WHERE b.tax_regime_code = status.tax_regime_code
5880: AND b.tax = status.tax
5881: AND b.tax_status_code = status.tax_status_code
5882: AND b.content_owner_id = sd_status.first_pty_org_id