APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_EN_STDNT_PS_ATT

Line 1306: l_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;

1302: FROM igs_ps_unit_ofr_opt
1303: WHERE uoo_id = p_uoo_id;
1304: l_location_rec c_location%ROWTYPE;
1305:
1306: l_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE;
1307: v_message_name fnd_new_messages.message_name%TYPE;
1308: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1309: l_chk_floc igs_ps_unit_ofr_opt.location_cd%TYPE ;
1310: l_message VARCHAR2(30);

Line 1452: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;

1448:
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);

Line 3394: FROM igs_en_stdnt_ps_att

3390: ORDER BY preference_order;
3391:
3392: CURSOR cur_program(p_person_id NUMBER , p_course_cd VARCHAR2 ,p_version_number NUMBER) IS
3393: SELECT 'X'
3394: FROM igs_en_stdnt_ps_att
3395: WHERE person_id = p_person_id AND
3396: course_cd = p_course_cd AND
3397: version_number = p_version_number;
3398:

Line 3401: FROM igs_en_stdnt_ps_att sca,

3397: version_number = p_version_number;
3398:
3399: CURSOR cur_org(p_person_id NUMBER , p_org_unit_cd VARCHAR2) IS
3400: SELECT 'X'
3401: FROM igs_en_stdnt_ps_att sca,
3402: igs_ps_ver pv
3403: WHERE sca.person_id = p_person_id AND
3404: sca.course_cd = pv.course_cd AND
3405: sca.version_number = pv.version_number AND

Line 3410: FROM igs_en_stdnt_ps_att spa,

3406: pv.responsible_org_unit_cd = p_org_unit_cd;
3407:
3408: CURSOR cur_unit_set(p_person_id NUMBER , p_unit_set_cd VARCHAR2 ,p_us_version_number NUMBER) IS
3409: SELECT 'X'
3410: FROM igs_en_stdnt_ps_att spa,
3411: igs_as_su_setatmpt sus
3412: WHERE spa.person_id = p_person_id AND
3413: sus.person_id = spa.person_id AND
3414: spa.course_cd = sus.course_cd AND

Line 4362: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

4358: --
4359: -- Cursor to find Intermission Type and Start Date for a given Person and Program.
4360: --
4361: CURSOR cur_intermission_details (
4362: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4363: cp_program_cd IGS_PS_VER.course_cd%TYPE
4364: ) IS
4365: SELECT sci.intermission_type,
4366: sci.start_dt,

Line 4370: igs_en_stdnt_ps_att spa

4366: sci.start_dt,
4367: sci.approved
4368: FROM igs_en_stdnt_ps_intm sci,
4369: IGS_EN_INTM_TYPES eit,
4370: igs_en_stdnt_ps_att spa
4371: WHERE sci.person_id = cp_person_id
4372: AND sci.course_cd = cp_program_cd
4373: AND sci.approved = eit.appr_reqd_ind
4374: AND eit.intermission_type = sci.intermission_type