APPS.IGS_PE_RELATIONSHIPS_PKG dependencies on IGS_PE_ADDR_V

Line 28: CURSOR c_student_addr_prim (cp_person_id igs_pe_addr_v.person_id%TYPE,

24:
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,

Line 64: CURSOR c_student_addr (cp_person_id igs_pe_addr_v.person_id%TYPE,

60: hps.status= 'A' AND
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,