APPS.ZX_TRN_VALIDATION_PKG dependencies on HZ_PARTY_SITES

Line 152: hz_party_sites hzps

148: from zx_registrations
149: where party_tax_profile_id = (select s.party_tax_profile_id
150: from zx_party_tax_profile s,
151: zx_party_tax_profile ptp,
152: hz_party_sites hzps
153: where ptp.party_tax_profile_id = c_ptp_id
154: and ptp.party_id = hzps.party_site_id
155: and hzps.party_id = s.party_id
156: and s.party_type_code = 'THIRD_PARTY')

Line 281: hz_party_sites ps

277:
278: SELECT distinct p.party_name, nvl(ps.party_site_name, p.address1||' '||p.address2||' '||p.address3||' '||p.address4||' '||p.city||' '||p.state) party_site_name
279: INTO l_party_name, l_party_site_name
280: FROM hz_parties p,
281: hz_party_sites ps
282: WHERE p.party_id = ps.party_id
283: AND ps.party_site_id = l_party_id;
284:
285: if x_party_name_token is null then

Line 385: HZ_PARTY_SITES HZS,

381: HZP.CITY||' '||
382: HZP.STATE) PARTY_SITE_NAME
383: INTO l_party_name, l_party_site_name
384: FROM ZX_REGISTRATIONS REG,
385: HZ_PARTY_SITES HZS,
386: HZ_PARTIES HZP,
387: ZX_PARTY_TAX_PROFILE ZXP
388: WHERE HZP.PARTY_ID = HZS.PARTY_ID
389: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID

Line 395: HZ_PARTY_SITES HZPS

391: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
392: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
393: FROM ZX_PARTY_TAX_PROFILE S,
394: ZX_PARTY_TAX_PROFILE PTP,
395: HZ_PARTY_SITES HZPS
396: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
397: AND PTP.PARTY_ID = HZPS.PARTY_ID
398: AND HZPS.PARTY_SITE_ID = S.PARTY_ID
399: AND S.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE')

Line 439: HZ_PARTY_SITES HZPS

435: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
436: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
437: FROM ZX_PARTY_TAX_PROFILE S,
438: ZX_PARTY_TAX_PROFILE PTP,
439: HZ_PARTY_SITES HZPS
440: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
441: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID
442: AND HZPS.PARTY_ID = S.PARTY_ID
443: AND S.PARTY_TYPE_CODE = 'THIRD_PARTY')

Line 754: HZ_PARTY_SITES HZPS

750: FROM ZX_REGISTRATIONS REG
751: WHERE REG.PARTY_TAX_PROFILE_ID IN (SELECT S.PARTY_TAX_PROFILE_ID
752: FROM ZX_PARTY_TAX_PROFILE S,
753: ZX_PARTY_TAX_PROFILE PTP,
754: HZ_PARTY_SITES HZPS
755: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
756: AND PTP.PARTY_ID = HZPS.PARTY_ID
757: AND HZPS.PARTY_SITE_ID = S.PARTY_ID
758: AND S.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE')