APPS.IGS_PR_GEN_006 dependencies on IGS_PR_SDT_PR_UNT_ST

Line 2774: FROM igs_pr_sdt_pr_unt_st spus

2770:
2771: CURSOR c_spus IS
2772: SELECT spus.unit_set_cd,
2773: spus.version_number
2774: FROM igs_pr_sdt_pr_unt_st spus
2775: WHERE spus.person_id = p_person_id AND
2776: spus.course_cd = p_course_cd AND
2777: spus.spo_sequence_number = p_spo_sequence_number;
2778:

Line 2780: unit_set_cd igs_pr_sdt_pr_unt_st.unit_set_cd%TYPE,

2776: spus.course_cd = p_course_cd AND
2777: spus.spo_sequence_number = p_spo_sequence_number;
2778:
2779: TYPE r_spus_record_type IS RECORD (
2780: unit_set_cd igs_pr_sdt_pr_unt_st.unit_set_cd%TYPE,
2781: version_number igs_pr_sdt_pr_unt_st.version_number%TYPE);
2782: r_spus_record r_spus_record_type;
2783:
2784: TYPE t_spus_table IS TABLE OF r_spus_record%TYPE

Line 2781: version_number igs_pr_sdt_pr_unt_st.version_number%TYPE);

2777: spus.spo_sequence_number = p_spo_sequence_number;
2778:
2779: TYPE r_spus_record_type IS RECORD (
2780: unit_set_cd igs_pr_sdt_pr_unt_st.unit_set_cd%TYPE,
2781: version_number igs_pr_sdt_pr_unt_st.version_number%TYPE);
2782: r_spus_record r_spus_record_type;
2783:
2784: TYPE t_spus_table IS TABLE OF r_spus_record%TYPE
2785: INDEX BY BINARY_INTEGER;