APPS.ZX_VALIDATE_API_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 2318: FROM zx_party_tax_profile ptp,

2314: --Bug 4703541
2315: CASE WHEN (header.ESTABLISHMENT_ID IS NOT NULL
2316: AND NOT EXISTS
2317: (SELECT 1
2318: FROM zx_party_tax_profile ptp,
2319: XLE_ETB_PROFILES etb
2320: WHERE ptp.party_id = etb.party_id
2321: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
2322: AND header.ESTABLISHMENT_ID = etb.ESTABLISHMENT_ID)

Line 2328: FROM zx_party_tax_profile ptp,

2324: OR
2325: (header.LEGAL_ENTITY_ID IS NOT NULL
2326: AND NOT EXISTS
2327: (SELECT 1
2328: FROM zx_party_tax_profile ptp,
2329: XLE_ENTITY_PROFILES etp
2330: WHERE ptp.party_id = etp.party_id
2331: AND ptp.party_type_code = 'FIRST_PARTY'
2332: AND header.LEGAL_ENTITY_ID = etp.LEGAL_ENTITY_ID)

Line 3834: (SELECT 1 FROM zx_party_tax_profile

3830: -- Check for SHIP_TO_PARTY_ID
3831: /*
3832: nvl2(lines_gt.SHIP_TO_PARTY_ID,
3833: CASE WHEN (NOT EXISTS
3834: (SELECT 1 FROM zx_party_tax_profile
3835: WHERE party_id =
3836: lines_gt.SHIP_TO_PARTY_ID
3837: AND party_type_code = 'THIRD_PARTY'))
3838: THEN 'Y'

Line 3845: (SELECT 1 FROM zx_party_tax_profile

3841:
3842: -- Check for SHIP_FROM_PARTY_ID
3843: nvl2(lines_gt.SHIP_FROM_PARTY_ID,
3844: CASE WHEN (NOT EXISTS
3845: (SELECT 1 FROM zx_party_tax_profile
3846: WHERE party_id =
3847: lines_gt.SHIP_FROM_PARTY_ID
3848: AND party_type_code = 'THIRD_PARTY'))
3849: THEN 'Y'

Line 3856: (SELECT 1 FROM zx_party_tax_profile

3852:
3853: -- Check for BILL_TO_PARTY_ID
3854: nvl2(lines_gt.BILL_TO_PARTY_ID,
3855: CASE WHEN (NOT EXISTS
3856: (SELECT 1 FROM zx_party_tax_profile
3857: WHERE party_id =
3858: lines_gt.BILL_TO_PARTY_ID
3859: AND party_type_code = 'THIRD_PARTY'))
3860: THEN 'Y'

Line 3867: (SELECT 1 FROM zx_party_tax_profile

3863:
3864: -- Check for BILL_FROM_PARTY_ID
3865: nvl2(lines_gt.BILL_FROM_PARTY_ID,
3866: CASE WHEN (NOT EXISTS
3867: (SELECT 1 FROM zx_party_tax_profile
3868: WHERE party_id =
3869: lines_gt.BILL_FROM_PARTY_ID
3870: AND party_type_code = 'THIRD_PARTY'))
3871: THEN 'Y'

Line 3878: (SELECT 1 FROM zx_party_tax_profile

3874:
3875: -- Check for SHIP_TO_PARTY_SITE_ID
3876: nvl2(lines_gt.SHIP_TO_PARTY_SITE_ID,
3877: CASE WHEN (NOT EXISTS
3878: (SELECT 1 FROM zx_party_tax_profile
3879: WHERE party_id =
3880: lines_gt.SHIP_TO_PARTY_SITE_ID
3881: AND party_type_code = 'THIRD_PARTY_SITE'))
3882: THEN 'Y'

Line 3889: (SELECT 1 FROM zx_party_tax_profile

3885:
3886: -- Check for SHIP_FROM_PARTY_SITE_ID
3887: nvl2(lines_gt.SHIP_FROM_PARTY_SITE_ID,
3888: CASE WHEN (NOT EXISTS
3889: (SELECT 1 FROM zx_party_tax_profile
3890: WHERE party_id =
3891: lines_gt.SHIP_FROM_PARTY_SITE_ID
3892: AND party_type_code = 'THIRD_PARTY_SITE'))
3893: THEN 'Y'

Line 3900: (SELECT 1 FROM zx_party_tax_profile

3896:
3897: -- Check for BILL_TO_PARTY_SITE_ID
3898: nvl2(lines_gt.BILL_TO_PARTY_SITE_ID,
3899: CASE WHEN (NOT EXISTS
3900: (SELECT 1 FROM zx_party_tax_profile
3901: WHERE party_id =
3902: lines_gt.BILL_TO_PARTY_SITE_ID
3903: AND party_type_code = 'THIRD_PARTY_SITE'))
3904: THEN 'Y'

Line 3911: (SELECT 1 FROM zx_party_tax_profile

3907:
3908: -- Check for BILL_FROM_PARTY_SITE_ID
3909: nvl2(lines_gt.BILL_FROM_PARTY_SITE_ID,
3910: CASE WHEN (NOT EXISTS
3911: (SELECT 1 FROM zx_party_tax_profile
3912: WHERE party_id =
3913: lines_gt.BILL_FROM_PARTY_SITE_ID
3914: AND party_type_code = 'THIRD_PARTY_SITE'))
3915: THEN 'Y'