APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 2295: CURSOR c_org_unit (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

2291: (sua.uoo_id = p_uoo_id AND
2292: sua.unit_attempt_status = 'WAITLISTED') ) AND
2293: NVL(sua.no_assessment_ind ,'N') = 'N' ;
2294:
2295: CURSOR c_org_unit (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2296: SELECT uop.owner_org_unit_cd,
2297: ou.start_dt
2298: FROM igs_ps_unit_ofr_opt_all uop,
2299: igs_or_inst_org_base_v ou