APPS.IGS_PE_RELATIONSHIPS_PKG dependencies on HZ_LOCATIONS

Line 50: HZ_LOCATIONS hl,

46: hl.address_lines_phonetic,
47: hl.delivery_point_code,
48: hps.status
49: FROM
50: HZ_LOCATIONS hl,
51: hz_party_sites hps,
52: hz_party_site_uses hpsu,
53: igs_pe_hz_pty_sites ihps
54: WHERE

Line 86: HZ_LOCATIONS hl,

82: hl.address_lines_phonetic,
83: hl.delivery_point_code,
84: hps.status
85: FROM
86: HZ_LOCATIONS hl,
87: hz_party_sites hps,
88: hz_party_site_uses hpsu,
89: igs_pe_hz_pty_sites ihps
90: WHERE

Line 130: l_location_ovn hz_locations.object_version_number%TYPE;

126: l_object_version_number NUMBER;
127: tmp_var VARCHAR2(2000);
128: tmp_var1 VARCHAR2(2000);
129: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
130: l_location_ovn hz_locations.object_version_number%TYPE;
131: l_profile_addr_usage VARCHAR2(30);
132:
133: BEGIN
134: p_validate := TRUE;