APPS.IGS_PE_RELATIONSHIPS_PKG dependencies on HZ_PARTY_SITE_USES

Line 29: cp_site_use_type hz_party_site_uses.site_use_type%TYPE) IS

25: --
26: -- cursor to fetch the address of the student
27: --
28: CURSOR c_student_addr_prim (cp_person_id igs_pe_addr_v.person_id%TYPE,
29: cp_site_use_type hz_party_site_uses.site_use_type%TYPE) IS
30: SELECT
31: ihps.START_DATE START_DT, --hps.START_DATE_ACTIVE START_DT,
32: hps.party_site_id,
33: ihps.END_DATE END_DT, -- hps.END_DATE_ACTIVE END_DT,

Line 52: hz_party_site_uses hpsu,

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
56: hps.party_id = cp_person_id AND

Line 65: cp_site_use_type hz_party_site_uses.site_use_type%TYPE) IS

61: hpsu.status= 'A' AND
62: hps.identifying_address_flag = 'Y';
63:
64: CURSOR c_student_addr (cp_person_id igs_pe_addr_v.person_id%TYPE,
65: cp_site_use_type hz_party_site_uses.site_use_type%TYPE) IS
66: SELECT
67: ihps.START_DATE START_DT, --hps.START_DATE_ACTIVE START_DT,
68: hps.party_site_id,
69: ihps.END_DATE END_DT, -- hps.END_DATE_ACTIVE END_DT,

Line 88: hz_party_site_uses hpsu,

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
92: hps.party_id = cp_person_id AND

Line 243: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

239: l_last_update_date := NULL;
240: l_rowid := NULL;
241: l_object_version_number := NULL;
242:
243: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
244: p_action => 'INSERT',
245: p_rowid => l_rowid,
246: p_party_site_use_id => l_party_site_use_id,
247: p_party_site_id => l_party_site_id,