APPS.IGS_PE_PERSON_SS_PKG dependencies on HZ_LOCATIONS

Line 770: p_location_ovn IN OUT NOCOPY hz_locations.object_version_number%TYPE,

766: p_country IN VARCHAR2,
767: p_country_cd IN VARCHAR2,
768: p_postal_code IN VARCHAR2,
769: p_ident_addr_flag IN VARCHAR2,
770: p_location_ovn IN OUT NOCOPY hz_locations.object_version_number%TYPE,
771: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
772: p_status IN hz_party_sites.status%TYPE
773: )
774: IS

Line 2133: FROM hz_locations hl, hz_party_sites hps

2129: ) RETURN BOOLEAN IS
2130:
2131: CURSOR c_dup_loc(cp_address VARCHAR2) IS
2132: SELECT 1
2133: FROM hz_locations hl, hz_party_sites hps
2134: WHERE hl.COUNTRY = p_country AND
2135: UPPER(hl.address1||'-'||hl.address2||'-'||hl.address3||'-'||hl.address4||'-'||hl.city||'-'||hl.state||'-'||
2136: hl.province||'-'||hl.county||'-'||hl.postal_code) = cp_address AND
2137: hl.location_id = hps.location_id and

Line 2347: hz_locations hl,

2343: hl.address_lines_phonetic,
2344: hl.delivery_point_code,
2345: hps.status
2346: FROM
2347: hz_locations hl,
2348: hz_party_sites hps,
2349: igs_pe_hz_pty_sites ihps
2350: WHERE hl.location_id = hps.location_id
2351: AND hps.party_id = cp_subject_id

Line 2392: l_location_ovn hz_locations.object_version_number%TYPE;

2388: l_location_id NUMBER;
2389: l_loc_rowid VARCHAR2(25);
2390: rec_student_addr c_location%ROWTYPE;
2391: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2392: l_location_ovn hz_locations.object_version_number%TYPE;
2393: l_hz_rel_ovn hz_relationships.object_version_number%TYPE;
2394: l_party_site_id NUMBER;
2395: l_last_update_date DATE;
2396: l_party_site_use_rowid VARCHAR2(25);