APPS.IGS_FI_GEN_005 dependencies on IGS_LOOKUPS_VIEW

Line 84: v_trigger_fired igs_lookups_view.lookup_code%TYPE;

80: cst_institutn CONSTANT VARCHAR2(10) := 'INSTITUTN';
81: v_liability BOOLEAN := FALSE;
82: v_load_found BOOLEAN := FALSE;
83: v_dummy CHAR(1);
84: v_trigger_fired igs_lookups_view.lookup_code%TYPE;
85: v_index BINARY_INTEGER;
86: r_suaeh IGS_FI_GET_SUAEH.r_t_suaeh_dtl;
87: v_ret_cal_type igs_ca_type.cal_type%TYPE;
88: v_ret_ci_sequence_number igs_ca_type.cal_type%TYPE;

Line 134: CURSOR c_scas ( cp_course_attempt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE ) IS

130: -- igs_fi_gen_001.finp_get_lcfi_reln
131:
132: -- check if the IGS_PS_COURSE attempt status is fee assessible
133:
134: CURSOR c_scas ( cp_course_attempt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE ) IS
135:
136: SELECT 'x'
137: FROM IGS_LOOKUPS_view scas
138: WHERE scas.lookup_code = cp_course_attempt_status AND

Line 137: FROM IGS_LOOKUPS_view scas

133:
134: CURSOR c_scas ( cp_course_attempt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE ) IS
135:
136: SELECT 'x'
137: FROM IGS_LOOKUPS_view scas
138: WHERE scas.lookup_code = cp_course_attempt_status AND
139: scas.lookup_type = 'CRS_ATTEMPT_STATUS' AND
140: scas.fee_ass_ind = 'Y';
141:

Line 144: CURSOR c_suas ( cp_unit_attempt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE) IS

140: scas.fee_ass_ind = 'Y';
141:
142: -- check if the IGS_PS_UNIT attempt status is fee assessible
143:
144: CURSOR c_suas ( cp_unit_attempt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE) IS
145:
146: SELECT 'x'
147: FROM IGS_LOOKUPS_view suas
148: WHERE suas.lookup_code = cp_unit_attempt_status AND

Line 147: FROM IGS_LOOKUPS_view suas

143:
144: CURSOR c_suas ( cp_unit_attempt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE) IS
145:
146: SELECT 'x'
147: FROM IGS_LOOKUPS_view suas
148: WHERE suas.lookup_code = cp_unit_attempt_status AND
149: suas.lookup_type = 'UNIT_ATTEMPT_STATUS' AND
150: suas.fee_ass_ind = 'Y';
151:

Line 418: IGS_LOOKUPS_view suas

414: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,
415: cp_v_audit_only VARCHAR2) IS
416: SELECT 'X'
417: FROM IGS_EN_SU_ATTEMPT sua,
418: IGS_LOOKUPS_view suas
419: WHERE sua.person_id = p_person_id AND
420: sua.course_cd = p_course_cd AND
421: ( sua.unit_cd = cp_unit_cd OR cp_unit_cd IS NULL) AND
422: (cp_version_number IS NULL OR

Line 477: igs_lookups_view suas

473: CURSOR c_sua_audit_one (cp_person_id NUMBER,
474: cp_course_cd VARCHAR2) IS
475: SELECT 'X'
476: FROM igs_en_su_attempt sua,
477: igs_lookups_view suas
478: WHERE sua.person_id = p_person_id
479: AND sua.course_cd = p_course_cd
480: AND suas.lookup_type = g_v_sua_status
481: AND suas.lookup_code = sua.unit_attempt_status

Line 872: v_trigger_fired igs_lookups_view.lookup_code%TYPE;

868: p_attendance_type IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
869: RETURN CHAR AS
870: BEGIN
871: DECLARE
872: v_trigger_fired igs_lookups_view.lookup_code%TYPE;
873: BEGIN
874: IF finp_val_fee_trigger(p_fee_cat,
875: p_fee_cal_type,
876: p_fee_ci_sequence_number,