APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_PS_UNIT_OFR_OPT

Line 553: FROM igs_ps_unit_ofr_opt

549: -- Cursor for getting the Teaching Calendar Type and its Sequence number for the UOO_ID passed
550: CURSOR cur_uoo_id
551: IS
552: SELECT unit_cd, version_number, cal_type, ci_sequence_number
553: FROM igs_ps_unit_ofr_opt
554: WHERE uoo_id = p_uoo_id;
555:
556: -- added by ckasu as a part EN317 SS UI bug#4377985
557:

Line 961: FROM igs_ps_unit_ofr_opt

957: -- Cursor for getting the Teaching Calendar Type and its Sequence number for the UOO_ID passed
958: CURSOR cur_uoo_id
959: IS
960: SELECT unit_cd, version_number, cal_type, ci_sequence_number
961: FROM igs_ps_unit_ofr_opt
962: WHERE uoo_id = p_uoo_id;
963:
964: CURSOR cur_min_cp_config IS
965: SELECT ecpd.config_min_cp_valdn, ecpd.enforce_date_alias

Line 1799: FROM igs_ps_unit_ofr_opt

1795: -- Cursor for getting the Teaching Calendar Type and its Sequence number for the UOO_ID passed
1796: CURSOR cur_uoo_id
1797: IS
1798: SELECT unit_cd, version_number, cal_type, ci_sequence_number
1799: FROM igs_ps_unit_ofr_opt
1800: WHERE uoo_id = p_uoo_id;
1801:
1802: -- Cursor for getting the minimum progression credit points that are defined
1803: CURSOR cur_min_progression_cp(cp_effective_date DATE)

Line 1970: FROM igs_ps_unit_ofr_opt

1966: -- Cursor for getting the Teaching Calendar Type and its Sequence number for the UOO_ID passed
1967: CURSOR cur_uoo_id
1968: IS
1969: SELECT unit_cd, version_number, cal_type, ci_sequence_number
1970: FROM igs_ps_unit_ofr_opt
1971: WHERE uoo_id = p_uoo_id;
1972:
1973: -- Cursor for getting the maximum progression credit points that are defined
1974: CURSOR cur_max_progression_cp(cp_effective_date DATE)

Line 2227: FROM igs_ps_unit_ofr_opt

2223: --
2224: -- Cursor to fetch the Unit Offering Details
2225: CURSOR cur_uoo_id IS
2226: SELECT unit_cd, version_number, cal_type, ci_sequence_number
2227: FROM igs_ps_unit_ofr_opt
2228: WHERE uoo_id = p_uoo_id;
2229:
2230:
2231: -- Cursor to fetch the Cross faculty Element restrictions

Line 2298: FROM igs_ps_unit_ofr_opt_all uop,

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
2300: WHERE uop.uoo_id = cp_uoo_id AND
2301: uop.owner_org_unit_cd = ou.party_number AND
2302: ou.inst_org_ind = 'O' ;