APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_PS_AWD

Line 121: CURSOR c_grad_sch (cp_award_cd igs_ps_awd.award_cd%TYPE ) IS

117: AND Awarding_body = l_awarding_body;
118: cur_qual_dets_val Cur_qual_dets%ROWTYPE;
119:
120: --smaddali added cursor for bug 2409543 to get the grading schema cd associated to the qualification (award)
121: CURSOR c_grad_sch (cp_award_cd igs_ps_awd.award_cd%TYPE ) IS
122: SELECT grading_schema_cd , gs_version_number
123: FROM igs_ps_awd
124: WHERE award_cd = cp_award_cd ;
125: c_grad_sch_rec c_grad_sch%ROWTYPE ;

Line 123: FROM igs_ps_awd

119:
120: --smaddali added cursor for bug 2409543 to get the grading schema cd associated to the qualification (award)
121: CURSOR c_grad_sch (cp_award_cd igs_ps_awd.award_cd%TYPE ) IS
122: SELECT grading_schema_cd , gs_version_number
123: FROM igs_ps_awd
124: WHERE award_cd = cp_award_cd ;
125: c_grad_sch_rec c_grad_sch%ROWTYPE ;
126:
127: --Check if Advanced standing details exists for the qualification or not.

Line 632: FROM igs_ps_awd

628: -- For validating Exam level/Qualification
629: CURSOR Cur_exam_lvl IS
630: SELECT grading_schema_cd,
631: gs_version_number
632: FROM igs_ps_awd
633: WHERE award_cd = p_uc_qual_cur.exam_level
634: AND s_award_type IN ('ENTRYQUAL', 'COURSE');
635:
636: exam_lvl_rec cur_exam_lvl%ROWTYPE;