APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 370: FROM igs_pe_alt_pers_id

366: CURSOR c_alternate_id (p_person_id igs_pe_person.person_id%TYPE,
367: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
368: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
369: SELECT api_person_id,person_id_type, LENGTH(api_person_id) api_length
370: FROM igs_pe_alt_pers_id
371: WHERE pe_person_id = p_person_id
372: AND person_id_type IN ('HUSID', 'UCASID', 'GTTRID', 'NMASID', 'SWASID')
373: AND Start_Dt <= cp_enrl_end_dt
374: AND (End_Dt IS NULL OR End_Dt >= cp_enrl_start_dt )

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

392:
393:
394: l_enrolled_su c_enr_su%ROWTYPE ;
395: l_prog_type igs_ps_ver_all.course_type%TYPE;
396: l_prev_pid_type igs_pe_alt_pers_id.person_id_type%TYPE := 'X' ;
397: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
398: l_id NUMBER;
399: l_awd_table igs_he_extract_fields_pkg.awd_table;
400: l_prog_rec_flag BOOLEAN := FALSE;

Line 397: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;

393:
394: l_enrolled_su c_enr_su%ROWTYPE ;
395: l_prog_type igs_ps_ver_all.course_type%TYPE;
396: l_prev_pid_type igs_pe_alt_pers_id.person_id_type%TYPE := 'X' ;
397: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
398: l_id NUMBER;
399: l_awd_table igs_he_extract_fields_pkg.awd_table;
400: l_prog_rec_flag BOOLEAN := FALSE;
401: l_prog_type_rec_flag BOOLEAN := FALSE;