APPS.IGS_PE_WF_GEN dependencies on HZ_PARTY_SITES

Line 306: FROM hz_parties hp, hz_party_sites hps

302: IS
303:
304: CURSOR cur_get_party_id(cp_party_site_id NUMBER) IS
305: SELECT party_number, party_name, location_id,hp.party_type,hp.party_id
306: FROM hz_parties hp, hz_party_sites hps
307: WHERE hp.party_id = hps.party_id AND
308: (hp.party_type = 'PERSON' OR hp.party_type = 'ORGANIZATION') AND
309: hp.status = 'A' AND
310: hps.party_site_id = cp_party_site_id;

Line 317: hz_party_sites hps,

313: SELECT hzl.address1, hzl.address2, hzl.address3, hzl.address4, hzl.city, hzl.province, hzl.state ,
314: hzl.county, hzl.postal_code, hzl.country, hzl.delivery_point_code ,hzp.party_number,
315: hzp.party_name,hps.identifying_address_flag
316: FROM
317: hz_party_sites hps,
318: hz_locations hzl,
319: hz_parties hzp
320: WHERE
321: hps.party_site_id=cp_party_site_id AND

Line 572: FROM hz_parties hp, hz_party_sites hps, igs_pe_hz_parties php

568:
569: CURSOR chk_oss_party(cp_party_site_id NUMBER) IS
570: SELECT hp.party_number, hp.party_name, hps.location_id,
571: php.inst_org_ind, hps.identifying_address_flag, php.oss_org_unit_cd
572: FROM hz_parties hp, hz_party_sites hps, igs_pe_hz_parties php
573: WHERE hp.party_id = hps.party_id
574: AND hp.party_id = php.party_id
575: AND hp.status = 'A'
576: AND hps.status = 'A'