APPS.IGS_EN_GEN_015 dependencies on IGS_EN_ELGB_OVR_UOO

Line 220: igs_en_elgb_ovr_uoo eou

216: SELECT eou.step_override_limit,
217: step_override_type
218: FROM igs_en_elgb_ovr_step eos,
219: igs_en_elgb_ovr eoa ,
220: igs_en_elgb_ovr_uoo eou
221: WHERE eoa.elgb_override_id = eos.elgb_override_id
222: AND eoa.cal_type = cp_cal_type
223: AND eoa.ci_sequence_number = cp_cal_seq_number
224: AND eoa.person_id = p_person_id

Line 242: igs_en_elgb_ovr_uoo eou

238: SELECT eou.step_override_limit,
239: step_override_type
240: FROM igs_en_elgb_ovr_step eos,
241: igs_en_elgb_ovr eoa ,
242: igs_en_elgb_ovr_uoo eou
243: WHERE eoa.elgb_override_id = eos.elgb_override_id
244: AND eoa.cal_type = cp_cal_type
245: AND eoa.ci_sequence_number = cp_cal_seq_number
246: AND eoa.person_id = p_person_id

Line 270: FROM igs_en_elgb_ovr_uoo eou

266: AND eoa.ci_sequence_number = cp_cal_seq_number
267: AND eoa.person_id = p_person_id
268: AND eos.step_override_type = p_eligibility_step_type
269: AND NOT EXISTS ( SELECT 'X'
270: FROM igs_en_elgb_ovr_uoo eou
271: WHERE eos.elgb_ovr_step_id = eou.elgb_ovr_step_id );
272: --
273: -- Cursor to finds the Teaching Calendar for a Unit Section.
274: --

Line 1516: igs_en_elgb_ovr_uoo eou

1512: CURSOR cur_uoo_appr_cp (cp_cal_type VARCHAR2, cp_sequence_number NUMBER) IS
1513: SELECT eou.step_override_limit
1514: FROM igs_en_elgb_ovr_step eos,
1515: igs_en_elgb_ovr eo ,
1516: igs_en_elgb_ovr_uoo eou
1517: WHERE eos.step_override_type = 'VAR_CREDIT_APPROVAL' AND
1518: eos.elgb_override_id = eo.elgb_override_id AND
1519: eo.person_id = p_person_id AND
1520: eo.cal_type = cp_cal_type AND

Line 1532: igs_en_elgb_ovr_uoo eou

1528: CURSOR cur_unit_appr_cp(cp_unit_cd VARCHAR2, cp_version_number NUMBER, cp_cal_type VARCHAR2, cp_sequence_number NUMBER , cp_uoo_id NUMBER) IS
1529: SELECT eou.step_override_limit
1530: FROM igs_en_elgb_ovr_step eos,
1531: igs_en_elgb_ovr eo ,
1532: igs_en_elgb_ovr_uoo eou
1533: WHERE eos.step_override_type = 'VAR_CREDIT_APPROVAL' AND
1534: eos.ELGB_OVERRIDE_ID = eo.ELGB_OVERRIDE_ID AND
1535: eo.person_id = p_person_id AND
1536: eou.unit_cd = cp_unit_cd AND

Line 1994: -- to refer to igs_en_elgb_ovr_uoo as part of deny/warn behaviour build #2829272

1990: --Nishikant 01NOV2002 SEVIS Build. Enh Bug#2641905. notification flag was
1991: -- being fetched from cursor, now modified to get it by
1992: -- calling the function igs_ss_enr_details.get_notification.
1993: --svanukur 04-jun-03 changed the declaration of the variable l_step_override_limit
1994: -- to refer to igs_en_elgb_ovr_uoo as part of deny/warn behaviour build #2829272
1995: -- smaddali 8-mar-06 Modified for bug#5091847
1996: -------------------------------------------------------------------------------------
1997: CURSOR cur_chk_sp_allowed( p_uoo_id NUMBER) IS
1998: SELECT special_permission_ind, cal_type, ci_sequence_number

Line 2029: l_step_override_limit igs_en_elgb_ovr_uoo.step_override_limit%TYPE;

2025: cur_step_def_var_rec step_rec;
2026: l_step_def_query VARCHAR2(2000);
2027:
2028:
2029: l_step_override_limit igs_en_elgb_ovr_uoo.step_override_limit%TYPE;
2030: l_spl_perm_rec cur_sp_exists%ROWTYPE;
2031: l_sp_allowed igs_ps_unit_ofr_opt.special_permission_ind%TYPE;
2032: l_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;