APPS.IGS_PR_CP_GPA dependencies on IGS_AS_SUA_REF_CDS

Line 2602: FROM igs_as_sua_ref_cds urc,

2598: WHERE ostr1.stat_type = p_stat_type AND ostr1.org_unit_cd = p_org_unit_cd;
2599:
2600: CURSOR c_org_included IS
2601: SELECT 'X'
2602: FROM igs_as_sua_ref_cds urc,
2603: igs_ge_ref_cd_type rct
2604: WHERE urc.person_id = p_person_id
2605: AND urc.uoo_id = p_uoo_id
2606: AND urc.course_cd = p_course_cd

Line 2621: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct

2617:
2618:
2619: CURSOR c_org_excluded IS
2620: SELECT 'X'
2621: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct
2622: WHERE urc.person_id = p_person_id
2623: AND urc.uoo_id = p_uoo_id
2624: AND urc.course_cd = p_course_cd
2625: AND urc.reference_cd_type = rct.reference_cd_type

Line 2642: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct

2638: WHERE INSTR.stat_type = p_stat_type;
2639:
2640: CURSOR c_inst_included IS
2641: SELECT 'X'
2642: FROM igs_as_sua_ref_cds urc, igs_ge_ref_cd_type rct
2643: WHERE urc.person_id = p_person_id
2644: AND urc.uoo_id = p_uoo_id
2645: AND urc.course_cd = p_course_cd
2646: AND urc.reference_cd_type = rct.reference_cd_type

Line 2658: FROM igs_as_sua_ref_cds src, igs_ge_ref_cd_type rct

2654:
2655:
2656: CURSOR c_inst_excluded IS
2657: SELECT 'X'
2658: FROM igs_as_sua_ref_cds src, igs_ge_ref_cd_type rct
2659: WHERE src.person_id = p_person_id
2660: AND src.uoo_id = p_uoo_id
2661: AND src.course_cd = p_course_cd
2662: AND src.reference_cd_type = rct.reference_cd_type