DBA Data[Home] [Help]

APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_PE_PERSON

Line 366: CURSOR c_alternate_id (p_person_id igs_pe_person.person_id%TYPE,

362: WHERE course_cd = cp_course_cd
363: AND version_number = cp_version_number;
364:
365: -- Alternate ID Cursor
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