APPS.ZX_VALIDATE_API_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 2610: FROM zx_party_tax_profile ptp,

2606: --Bug 4703541
2607: CASE WHEN (header.ESTABLISHMENT_ID IS NOT NULL
2608: AND NOT EXISTS
2609: (SELECT 1
2610: FROM zx_party_tax_profile ptp,
2611: XLE_ETB_PROFILES etb
2612: WHERE ptp.party_id = etb.party_id
2613: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
2614: AND header.ESTABLISHMENT_ID = etb.ESTABLISHMENT_ID)

Line 2620: FROM zx_party_tax_profile ptp,

2616: OR
2617: (header.LEGAL_ENTITY_ID IS NOT NULL
2618: AND NOT EXISTS
2619: (SELECT 1
2620: FROM zx_party_tax_profile ptp,
2621: XLE_ENTITY_PROFILES etp
2622: WHERE ptp.party_id = etp.party_id
2623: AND ptp.party_type_code = 'FIRST_PARTY'
2624: AND header.LEGAL_ENTITY_ID = etp.LEGAL_ENTITY_ID)

Line 4295: (SELECT 1 FROM zx_party_tax_profile

4291: -- Check for SHIP_TO_PARTY_ID
4292: /*
4293: nvl2(lines_gt.SHIP_TO_PARTY_ID,
4294: CASE WHEN (NOT EXISTS
4295: (SELECT 1 FROM zx_party_tax_profile
4296: WHERE party_id =
4297: lines_gt.SHIP_TO_PARTY_ID
4298: AND party_type_code = 'THIRD_PARTY'))
4299: THEN 'Y'

Line 4306: (SELECT 1 FROM zx_party_tax_profile

4302:
4303: -- Check for SHIP_FROM_PARTY_ID
4304: nvl2(lines_gt.SHIP_FROM_PARTY_ID,
4305: CASE WHEN (NOT EXISTS
4306: (SELECT 1 FROM zx_party_tax_profile
4307: WHERE party_id =
4308: lines_gt.SHIP_FROM_PARTY_ID
4309: AND party_type_code = 'THIRD_PARTY'))
4310: THEN 'Y'

Line 4317: (SELECT 1 FROM zx_party_tax_profile

4313:
4314: -- Check for BILL_TO_PARTY_ID
4315: nvl2(lines_gt.BILL_TO_PARTY_ID,
4316: CASE WHEN (NOT EXISTS
4317: (SELECT 1 FROM zx_party_tax_profile
4318: WHERE party_id =
4319: lines_gt.BILL_TO_PARTY_ID
4320: AND party_type_code = 'THIRD_PARTY'))
4321: THEN 'Y'

Line 4328: (SELECT 1 FROM zx_party_tax_profile

4324:
4325: -- Check for BILL_FROM_PARTY_ID
4326: nvl2(lines_gt.BILL_FROM_PARTY_ID,
4327: CASE WHEN (NOT EXISTS
4328: (SELECT 1 FROM zx_party_tax_profile
4329: WHERE party_id =
4330: lines_gt.BILL_FROM_PARTY_ID
4331: AND party_type_code = 'THIRD_PARTY'))
4332: THEN 'Y'

Line 4339: (SELECT 1 FROM zx_party_tax_profile

4335:
4336: -- Check for SHIP_TO_PARTY_SITE_ID
4337: nvl2(lines_gt.SHIP_TO_PARTY_SITE_ID,
4338: CASE WHEN (NOT EXISTS
4339: (SELECT 1 FROM zx_party_tax_profile
4340: WHERE party_id =
4341: lines_gt.SHIP_TO_PARTY_SITE_ID
4342: AND party_type_code = 'THIRD_PARTY_SITE'))
4343: THEN 'Y'

Line 4350: (SELECT 1 FROM zx_party_tax_profile

4346:
4347: -- Check for SHIP_FROM_PARTY_SITE_ID
4348: nvl2(lines_gt.SHIP_FROM_PARTY_SITE_ID,
4349: CASE WHEN (NOT EXISTS
4350: (SELECT 1 FROM zx_party_tax_profile
4351: WHERE party_id =
4352: lines_gt.SHIP_FROM_PARTY_SITE_ID
4353: AND party_type_code = 'THIRD_PARTY_SITE'))
4354: THEN 'Y'

Line 4361: (SELECT 1 FROM zx_party_tax_profile

4357:
4358: -- Check for BILL_TO_PARTY_SITE_ID
4359: nvl2(lines_gt.BILL_TO_PARTY_SITE_ID,
4360: CASE WHEN (NOT EXISTS
4361: (SELECT 1 FROM zx_party_tax_profile
4362: WHERE party_id =
4363: lines_gt.BILL_TO_PARTY_SITE_ID
4364: AND party_type_code = 'THIRD_PARTY_SITE'))
4365: THEN 'Y'

Line 4372: (SELECT 1 FROM zx_party_tax_profile

4368:
4369: -- Check for BILL_FROM_PARTY_SITE_ID
4370: nvl2(lines_gt.BILL_FROM_PARTY_SITE_ID,
4371: CASE WHEN (NOT EXISTS
4372: (SELECT 1 FROM zx_party_tax_profile
4373: WHERE party_id =
4374: lines_gt.BILL_FROM_PARTY_SITE_ID
4375: AND party_type_code = 'THIRD_PARTY_SITE'))
4376: THEN 'Y'