APPS.IGS_FI_VAL_FAS dependencies on IGS_LOOKUPS_VIEW

Line 4: skharida 09-feb-2006 Bug# 5018036 - SQL Tuning, changed to IGS_LOOKUPS_VAL instead to IGS_LOOKUPS_VIEW.

1: PACKAGE BODY IGS_FI_VAL_FAS AS
2: /* $Header: IGSFI23B.pls 120.2 2006/02/23 21:33:05 skharida noship $ */
3: /* Who When What
4: skharida 09-feb-2006 Bug# 5018036 - SQL Tuning, changed to IGS_LOOKUPS_VAL instead to IGS_LOOKUPS_VIEW.
5: uudayapr 07-dec-2004 ENH# 3167098, Modified finp_val_fas_ass_ind.
6: shtatiko 24-DEC-2003 Enh# 3167098, Modified finp_val_fas_ass_ind.
7: uudayapr 12-dec-2003 Bug#3080983 Modified the cursor c_fadv in the Function
8: finp_val_fas_balance .

Line 71: igs_lookups_view scas

67: SELECT scas.fee_ass_ind,
68: std.course_attempt_status
69: FROM igs_en_spa_terms sca,
70: igs_en_stdnt_ps_att std,
71: igs_lookups_view scas
72: WHERE sca.person_id = p_person_id
73: AND sca.program_cd = p_course_cd
74: AND sca.term_cal_type = l_v_load_cal_type
75: AND sca.term_sequence_number = l_n_load_ci_seq_number

Line 86: IGS_LOOKUPS_VIEW scas

82: CURSOR c_scaehv IS
83: SELECT scas.fee_ass_ind,
84: scaehv.course_attempt_status
85: FROM IGS_AS_SCAH_EFFECTIVE_H_V scaehv,
86: IGS_LOOKUPS_VIEW scas
87: WHERE
88: scaehv.person_id = p_person_id AND
89: scaehv.course_cd = p_course_cd AND
90: ((scaehv.fee_cat IS NULL AND