DBA Data[Home] [Help]

APPS.ZX_TRN_VALIDATION_PKG dependencies on HZ_PARTIES

Line 266: FROM hz_parties

262: IF p_party_type_code = 'THIRD_PARTY' THEN
263:
264: SELECT distinct party_name
265: INTO l_party_name
266: FROM hz_parties
267: WHERE party_id = l_party_id;
268:
269: if x_party_name_token is null then
270: x_party_name_token := x_party_name_token ||' '|| l_party_name;

Line 280: FROM hz_parties p,

276: ELSIF p_party_type_code = 'THIRD_PARTY_SITE' THEN
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:

Line 386: HZ_PARTIES HZP,

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
390: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID

Line 431: HZ_PARTIES HZP,

427:
428: SELECT HZP.PARTY_NAME
429: INTO l_party_name
430: FROM ZX_REGISTRATIONS REG,
431: HZ_PARTIES HZP,
432: ZX_PARTY_TAX_PROFILE ZXP
433: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
434: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
435: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'