APPS.IGS_EN_GEN_015 dependencies on IGS_EN_SPL_PERM

Line 2004: FROM igs_en_spl_perm

2000: WHERE uoo_id = p_uoo_id;
2001:
2002: CURSOR cur_sp_exists( p_person_id NUMBER, p_uoo_id NUMBER) IS
2003: SELECT approval_status, Transaction_type
2004: FROM igs_en_spl_perm
2005: WHERE student_person_id = p_person_id
2006: AND uoo_id =p_uoo_id
2007: AND REQUEST_TYPE = 'SPL_PERM'
2008: AND transaction_type <> 'WITHDRAWN';

Line 2308: FROM igs_en_spl_perm

2304:
2305:
2306: CURSOR c_audit_perm_exists( p_person_id NUMBER, p_uoo_id NUMBER) IS
2307: SELECT approval_status, transaction_type
2308: FROM igs_en_spl_perm
2309: WHERE student_person_id = p_person_id
2310: AND uoo_id =p_uoo_id
2311: AND REQUEST_TYPE = 'AUDIT_PERM'
2312: AND transaction_type <> 'WITHDRAWN';