APPS.IGS_AD_GEN_010 dependencies on IGS_EN_STDNT_PS_ATT

Line 238: v_enrol_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
235: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
236: v_adm_offer_dfrmnt_status
237: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;
238: v_enrol_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
239: v_tac_match BOOLEAN;
240: v_course_off_found BOOLEAN;
241: v_course_ins_found BOOLEAN;
242: CURSOR c_tac_id_api IS

Line 347: FROM IGS_EN_STDNT_PS_ATT sca,

343: CURSOR c_attn_mode(
344: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
345: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
346: SELECT am.govt_attendance_mode
347: FROM IGS_EN_STDNT_PS_ATT sca,
348: IGS_EN_ATD_MODE am
349: WHERE sca.course_cd = cp_course_cd AND
350: sca.person_id = cp_person_id AND
351: am.attendance_mode = sca.attendance_mode;