eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_GEN_004 dependencies on IGS_FI_FEE_STR_STAT

Line 123: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='ACTIVE';

119: v_exit_loop BOOLEAN := FALSE;
120: v_rec_found BOOLEAN := FALSE;
121: cst_tuition CONSTANT IGS_FI_F_CAT_FEE_LBL_SCA_RT_V.s_fee_type%TYPE := 'TUITION';
122: cst_active
123: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='ACTIVE';
124: cst_planned
125: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='PLANNED';
126: v_previous_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE;
127:

Line 125: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='PLANNED';

121: cst_tuition CONSTANT IGS_FI_F_CAT_FEE_LBL_SCA_RT_V.s_fee_type%TYPE := 'TUITION';
122: cst_active
123: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='ACTIVE';
124: cst_planned
125: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='PLANNED';
126: v_previous_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE;
127:
128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,
129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,

Line 128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,

124: cst_planned
125: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='PLANNED';
126: v_previous_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE;
127:
128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,
129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,
130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,
131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,
132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,

Line 151: igs_fi_fee_str_stat fsst,

147: far.attendance_type chg_rate_attendance_type,
148: far.attendance_mode chg_rate_attendance_mode
149: FROM igs_en_stdnt_ps_att spa,
150: igs_fi_f_cat_fee_lbl_v fcflv,
151: igs_fi_fee_str_stat fsst,
152: igs_fi_fee_as_rate far,
153: igs_fi_fee_type ft,
154: igs_fi_fee_as_rt cfar
155: WHERE spa.person_id = p_person_id

Line 214: igs_fi_fee_str_stat fsst,

210: far.attendance_mode chg_rate_attendance_mode
211: FROM igs_en_spa_terms spt,
212: igs_en_stdnt_ps_att spa,
213: igs_fi_f_cat_fee_lbl_v fcflv,
214: igs_fi_fee_str_stat fsst,
215: igs_fi_fee_as_rate far,
216: igs_fi_fee_type ft,
217: igs_fi_fee_as_rt cfar
218: WHERE spt.person_id = p_person_id