APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_OFR_OPT

Line 1286: FROM igs_ps_ofr_opt coo,

1282: -------------------------------------------------------------------------------------
1283: --
1284: CURSOR cur_chk_floc(p_coo_id NUMBER, p_uoo_id NUMBER) IS
1285: SELECT uoo.location_cd
1286: FROM igs_ps_ofr_opt coo,
1287: igs_ps_unit_ofr_opt uoo
1288: WHERE coo.coo_id = p_coo_id AND
1289: uoo.uoo_id = p_uoo_id AND
1290: uoo.location_cd = coo.location_cd;

Line 1295: FROM igs_ps_ofr_opt

1291:
1292:
1293: CURSOR cur_get_floc(p_coo_id NUMBER) IS
1294: SELECT location_cd
1295: FROM igs_ps_ofr_opt
1296: WHERE coo_id = p_coo_id;
1297:
1298:
1299: -- Cursor to get the unit location code

Line 1445: FROM igs_ps_ofr_opt

1441: WHERE uoo_id = p_uoo_id;
1442:
1443: CURSOR cur_get_fatt(p_coo_id NUMBER) IS
1444: SELECT attendance_mode
1445: FROM igs_ps_ofr_opt
1446: WHERE coo_id = p_coo_id;
1447:
1448:
1449: --

Line 1453: l_forced_att_mode igs_ps_ofr_opt.attendance_mode%TYPE;

1449: --
1450: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1451: l_unit_class_rec cur_unit_class%ROWTYPE ;
1452: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
1453: l_forced_att_mode igs_ps_ofr_opt.attendance_mode%TYPE;
1454: l_message VARCHAR2(30);
1455: l_message_icon VARCHAR2(1);
1456: l_message_token VARCHAR2(100);
1457: --