APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_EN_SPL_PERM

Line 3247: FROM igs_en_spl_perm

3243: WHERE uoo_id = p_uoo_id;
3244:
3245: CURSOR cur_sp_approve(p_person_id NUMBER,p_uoo_id NUMBER) IS
3246: SELECT approval_status
3247: FROM igs_en_spl_perm
3248: WHERE student_person_id = p_person_id AND
3249: uoo_id =p_uoo_id AND
3250: request_type = 'SPL_PERM' AND
3251: approval_status = 'A';

Line 3254: l_sp_approve igs_en_spl_perm.approval_status%TYPE ;

3250: request_type = 'SPL_PERM' AND
3251: approval_status = 'A';
3252:
3253: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3254: l_sp_approve igs_en_spl_perm.approval_status%TYPE ;
3255: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
3256:
3257: --
3258: -- begin of the function eval_spl_permission

Line 4685: -- exists in the table Igs_En_Spl_Perm for the given student and unit section

4681: -- prraj 23-Oct Created
4682: --------------------------------------------------------------------------------
4683:
4684: -- Cursor to check whether the approved audit permission record
4685: -- exists in the table Igs_En_Spl_Perm for the given student and unit section
4686: CURSOR c_approv_perm IS
4687: SELECT 'x'
4688: FROM Igs_En_Spl_Perm
4689: WHERE student_person_id = p_person_id

Line 4688: FROM Igs_En_Spl_Perm

4684: -- Cursor to check whether the approved audit permission record
4685: -- exists in the table Igs_En_Spl_Perm for the given student and unit section
4686: CURSOR c_approv_perm IS
4687: SELECT 'x'
4688: FROM Igs_En_Spl_Perm
4689: WHERE student_person_id = p_person_id
4690: AND uoo_id = p_uoo_id
4691: AND request_type = 'AUDIT_PERM'
4692: AND approval_status = 'A';