APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 1239: FROM igs_pe_alt_pers_id

1235: ( p_person_id IN igs_pe_person.person_id%TYPE,
1236: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1237: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1238: SELECT api_person_id,person_id_type, LENGTH(api_person_id) api_length
1239: FROM igs_pe_alt_pers_id
1240: WHERE pe_person_id = p_person_id
1241: AND person_id_type IN ('HUSID', 'UCASID', 'GTTRID', 'NMASID', 'SWASID')
1242: AND Start_Dt <= cp_enrl_end_dt
1243: AND ( End_Dt IS NULL OR End_Dt >= cp_enrl_start_dt )

Line 1246: l_prev_pid_type igs_pe_alt_pers_id.person_id_type%TYPE := 'X' ;

1242: AND Start_Dt <= cp_enrl_end_dt
1243: AND ( End_Dt IS NULL OR End_Dt >= cp_enrl_start_dt )
1244: AND (End_Dt IS NULL OR Start_Dt <> End_Dt)
1245: ORDER BY person_id_type, Start_Dt DESC ;
1246: l_prev_pid_type igs_pe_alt_pers_id.person_id_type%TYPE := 'X' ;
1247:
1248: l_awd_min_dt DATE;
1249: l_awd_max_dt DATE;
1250: l_awd_conf_start_dt DATE;

Line 1261: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;

1257: l_award_cd igs_ps_award.award_cd%TYPE;
1258: l_rec_count NUMBER := 0;
1259: l_message VARCHAR2(2000);
1260: l_return_type VARCHAR2(3);
1261: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
1262: l_id NUMBER;
1263: l_prev_person_id NUMBER := -1;
1264: l_prev_student_inst_number VARCHAR2(100) := '-1';
1265: