APPS.IGS_PE_RELATIONSHIPS_PKG dependencies on HZ_PARTY_SITES

Line 51: hz_party_sites hps,

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
55: hl.location_id = hps.location_id AND

Line 87: hz_party_sites hps,

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
91: hl.location_id = hps.location_id AND

Line 129: l_party_site_ovn hz_party_sites.object_version_number%TYPE;

125: l_site_use_id NUMBER;
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