APPS.IGS_PR_GEN_006 dependencies on IGS_PR_STDNT_PR_UNIT

Line 2885: cp_s_unit_type igs_pr_stdnt_pr_unit.s_unit_type%TYPE) IS

2881:
2882: v_pur_dup_rec c_pur_dup%ROWTYPE;
2883:
2884: CURSOR c_spu (
2885: cp_s_unit_type igs_pr_stdnt_pr_unit.s_unit_type%TYPE) IS
2886: SELECT spu.unit_cd
2887: FROM igs_pr_stdnt_pr_unit spu
2888: WHERE spu.person_id = p_person_id AND
2889: spu.course_cd = p_course_cd AND

Line 2887: FROM igs_pr_stdnt_pr_unit spu

2883:
2884: CURSOR c_spu (
2885: cp_s_unit_type igs_pr_stdnt_pr_unit.s_unit_type%TYPE) IS
2886: SELECT spu.unit_cd
2887: FROM igs_pr_stdnt_pr_unit spu
2888: WHERE spu.person_id = p_person_id AND
2889: spu.course_cd = p_course_cd AND
2890: spu.spo_sequence_number = p_spo_sequence_number AND
2891: spu.s_unit_type = cp_s_unit_type;

Line 2893: TYPE t_spu_type IS TABLE OF igs_pr_stdnt_pr_unit.unit_cd%TYPE

2889: spu.course_cd = p_course_cd AND
2890: spu.spo_sequence_number = p_spo_sequence_number AND
2891: spu.s_unit_type = cp_s_unit_type;
2892:
2893: TYPE t_spu_type IS TABLE OF igs_pr_stdnt_pr_unit.unit_cd%TYPE
2894: INDEX BY BINARY_INTEGER;
2895: v_spu_table t_spu_type;
2896: v_spu_index BINARY_INTEGER;
2897: