APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 9838: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

9834: c_term_con_rec c_term_con%ROWTYPE ;
9835: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
9836:
9837: -- smaddali added cursor for bug#3361317
9838: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
9839: SELECT party_number person_number
9840: FROM hz_parties
9841: WHERE party_id = cp_person_id ;
9842: l_person_number igs_pe_Person_base_v.person_number%TYPE;

Line 9842: l_person_number igs_pe_Person_base_v.person_number%TYPE;

9838: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
9839: SELECT party_number person_number
9840: FROM hz_parties
9841: WHERE party_id = cp_person_id ;
9842: l_person_number igs_pe_Person_base_v.person_number%TYPE;
9843:
9844: BEGIN
9845:
9846: -- Fetch the Person Details

Line 10621: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

10617: l_message VARCHAR2(2000);
10618:
10619:
10620: -- smaddali added cursor for bug#3361317
10621: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
10622: SELECT party_number person_number
10623: FROM hz_parties
10624: WHERE party_id = cp_person_id ;
10625: l_person_number igs_pe_Person_base_v.person_number%TYPE;

Line 10625: l_person_number igs_pe_Person_base_v.person_number%TYPE;

10621: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
10622: SELECT party_number person_number
10623: FROM hz_parties
10624: WHERE party_id = cp_person_id ;
10625: l_person_number igs_pe_Person_base_v.person_number%TYPE;
10626:
10627: TYPE INTRM_RECORDS IS TABLE OF NUMBER(15) NOT NULL INDEX BY BINARY_INTEGER;
10628: l_rec_list INTRM_RECORDS;
10629: l_rec_cnt NUMBER;