APPS.IGS_FI_GEN_001 dependencies on IGS_LOOKUPS_VIEW

Line 318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS

314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,
317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,
318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS
319: SELECT fas.s_transaction_type
320: FROM IGS_FI_FEE_AS fas,
321: IGS_LOOKUPS_view strty
322: WHERE fas.person_id = cp_person_id AND

Line 321: IGS_LOOKUPS_view strty

317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,
318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS
319: SELECT fas.s_transaction_type
320: FROM IGS_FI_FEE_AS fas,
321: IGS_LOOKUPS_view strty
322: WHERE fas.person_id = cp_person_id AND
323: fas.fee_type = cp_fee_type AND
324: fas.fee_cal_type = cp_fee_cal_type AND
325: NVL(fas.FEE_CAT, ' ') = NVL(cp_fee_cat, ' ') AND

Line 611: IGS_LOOKUPS_view suas

607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
608: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE) IS
609: SELECT 'X'
610: FROM IGS_EN_SU_ATTEMPT sua,
611: IGS_LOOKUPS_view suas
612: WHERE sua.person_id = p_person_id AND
613: sua.course_cd = p_course_cd AND
614: sua.unit_cd = cp_unit_cd AND
615: (cp_version_number IS NULL OR

Line 1141: FROM IGS_LOOKUPS_view strty

1137: fas.course_cd = p_course_cd AND
1138: fas.FEE_TYPE = ft.FEE_TYPE AND
1139: fas.S_TRANSACTION_TYPE in
1140: (SELECT strty.lookup_code
1141: FROM IGS_LOOKUPS_view strty
1142: WHERE strty.lookup_code = fas.S_TRANSACTION_TYPE AND
1143: strty.lookup_type = 'TRANSACTION_TYPE' AND
1144: strty.transaction_cat = cst_payment) AND
1145: fas.S_TRANSACTION_TYPE <> cst_discount AND