APPS.IGS_EN_GEN_012 dependencies on IGS_LOOKUPS_VIEW

Line 780: FROM IGS_LOOKUPS_VIEW

776: ORDER BY LOAD_START_DT ASC;
777:
778: CURSOR c_reason IS
779: SELECT meaning
780: FROM IGS_LOOKUPS_VIEW
781: WHERE lookup_type = 'CRS_ATTEMPT_STATUS'
782: AND lookup_CODE = 'DISCONTIN';
783:
784: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

Line 787: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;

783:
784: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
785: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
786: l_return_status VARCHAR2(10);
787: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
788:
789: BEGIN
790:
791: OPEN c_tl;

Line 2133: v_course_attempt_status IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;

2129: SELECT sca.course_attempt_status
2130: FROM IGS_EN_STDNT_PS_ATT sca
2131: WHERE sca.person_id = p_person_id AND
2132: sca.course_cd = p_course_cd;
2133: v_course_attempt_status IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
2134: v_new_course_attempt_status
2135: IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
2136: v_other_detail VARCHAR2(255);
2137: v_person_id IGS_PE_PERSON.person_id%TYPE;

Line 2135: IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;

2131: WHERE sca.person_id = p_person_id AND
2132: sca.course_cd = p_course_cd;
2133: v_course_attempt_status IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
2134: v_new_course_attempt_status
2135: IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
2136: v_other_detail VARCHAR2(255);
2137: v_person_id IGS_PE_PERSON.person_id%TYPE;
2138: /****************************************************************************
2139: History