APPS.ZX_TRN_VALIDATION_PKG dependencies on HZ_PARTIES

Line 289: FROM hz_parties

285: IF p_party_type_code = 'THIRD_PARTY' THEN
286:
287: SELECT party_name
288: INTO l_party_name
289: FROM hz_parties
290: WHERE party_id = l_party_id;
291:
292: if x_party_name_token is null then
293: x_party_name_token := l_party_name;

Line 303: FROM hz_parties p,

299: ELSIF p_party_type_code = 'THIRD_PARTY_SITE' THEN
300:
301: 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
302: INTO l_party_name, l_party_site_name
303: FROM hz_parties p,
304: hz_party_sites ps
305: WHERE p.party_id = ps.party_id
306: AND ps.party_site_id = l_party_id;
307:

Line 409: HZ_PARTIES HZP,

405: HZP.STATE) PARTY_SITE_NAME
406: INTO l_party_name, l_party_site_name
407: FROM ZX_REGISTRATIONS REG,
408: HZ_PARTY_SITES HZS,
409: HZ_PARTIES HZP,
410: ZX_PARTY_TAX_PROFILE ZXP
411: WHERE HZP.PARTY_ID = HZS.PARTY_ID
412: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
413: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID

Line 454: HZ_PARTIES HZP,

450:
451: SELECT HZP.PARTY_NAME
452: INTO l_party_name
453: FROM ZX_REGISTRATIONS REG,
454: HZ_PARTIES HZP,
455: ZX_PARTY_TAX_PROFILE ZXP
456: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
457: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
458: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'

Line 676: FROM hz_parties

672: p_error_buffer := 'ZX_REG_NUM_DUPLICATE';
673:
674: SELECT party_name
675: INTO l_party_name
676: FROM hz_parties
677: WHERE party_id = l_party_id;
678:
679: if x_party_name_token is null then
680: x_party_name_token := l_party_name;

Line 724: FROM hz_parties p,

720: SELECT distinct p.party_name,
721: nvl(ps.party_site_name, p.address1||' '||p.address2||' '||
722: p.address3||' '||p.address4||' '||p.city||' '||p.state) party_site_name
723: INTO l_party_name, l_party_site_name
724: FROM hz_parties p,
725: hz_party_sites ps
726: WHERE p.party_id = ps.party_id
727: AND ps.party_site_id = l_party_id;
728:

Line 844: HZ_PARTIES HZP,

840: HZP.CITY||' '||
841: HZP.STATE) PARTY_SITE_NAME
842: INTO l_ptp_id,l_party_name, l_party_site_name
843: FROM HZ_PARTY_SITES HZS,
844: HZ_PARTIES HZP,
845: ZX_PARTY_TAX_PROFILE ZXP
846: WHERE HZP.PARTY_ID = HZS.PARTY_ID
847: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
848: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'

Line 916: FROM HZ_PARTIES HZP,

912: AND lookup_code = 'THIRD_PARTY';
913:
914: SELECT ZXP.PARTY_TAX_PROFILE_ID,HZP.PARTY_NAME
915: INTO l_ptp_id,l_party_name
916: FROM HZ_PARTIES HZP,
917: ZX_PARTY_TAX_PROFILE ZXP
918: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
919: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
920: AND NOT EXISTS (SELECT S.PARTY_TAX_PROFILE_ID