DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PR_STDNT_PR_PS

Line 2663: FROM igs_pr_stdnt_pr_ps spc

2659: v_pce_dup_rec c_pce_dup%ROWTYPE;
2660:
2661: CURSOR c_spc IS
2662: SELECT spc.course_cd
2663: FROM igs_pr_stdnt_pr_ps spc
2664: WHERE spc.person_id = p_person_id AND
2665: spc.spo_course_cd = p_course_cd AND
2666: spc.spo_sequence_number = p_spo_sequence_number;
2667: TYPE t_spc_type IS TABLE OF igs_pr_stdnt_pr_ps.course_cd%TYPE

Line 2667: TYPE t_spc_type IS TABLE OF igs_pr_stdnt_pr_ps.course_cd%TYPE

2663: FROM igs_pr_stdnt_pr_ps spc
2664: WHERE spc.person_id = p_person_id AND
2665: spc.spo_course_cd = p_course_cd AND
2666: spc.spo_sequence_number = p_spo_sequence_number;
2667: TYPE t_spc_type IS TABLE OF igs_pr_stdnt_pr_ps.course_cd%TYPE
2668: INDEX BY BINARY_INTEGER;
2669:
2670: v_spc_table t_spc_type;
2671: v_spc_index BINARY_INTEGER;