APPS.IGF_SP_GEN_001 dependencies on IGS_PE_PERSON

Line 317: (p_person_id IN igs_pe_person.person_id%TYPE,

313: END get_sponsor_amts;
314:
315:
316: FUNCTION check_unit_attempt
317: (p_person_id IN igs_pe_person.person_id%TYPE,
318: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
319: p_ld_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
320: p_course_cd IN igs_ps_ver.course_cd%TYPE,
321: p_course_version_number IN igs_ps_ver.version_number%TYPE,

Line 344: CURSOR c_enroll (cp_person_id igs_pe_person.person_id%TYPE,

340: -------------------------------------------------------------------------------------
341: /*
342: cursor to see whether the student is actively enrolled in the unit or not
343: */
344: CURSOR c_enroll (cp_person_id igs_pe_person.person_id%TYPE,
345: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
346: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,
348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,