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.

APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_CA_DA_INST

Line 198: l_refund_dt_alias igs_ca_da_inst.dt_alias%TYPE;

194: CURSOR cur_control
195: IS
196: SELECT refund_dt_alias
197: FROM igs_fi_control;
198: l_refund_dt_alias igs_ca_da_inst.dt_alias%TYPE;
199:
200: CURSOR cur_alias_val (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
201: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
202: cp_date_alias igs_ca_da_inst.dt_alias%TYPE)

Line 202: cp_date_alias igs_ca_da_inst.dt_alias%TYPE)

198: l_refund_dt_alias igs_ca_da_inst.dt_alias%TYPE;
199:
200: CURSOR cur_alias_val (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
201: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
202: cp_date_alias igs_ca_da_inst.dt_alias%TYPE)
203: IS
204: SELECT alias_val
205: FROM igs_ca_da_inst_v
206: WHERE cal_type = cp_fee_cal_type

Line 205: FROM igs_ca_da_inst_v

201: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
202: cp_date_alias igs_ca_da_inst.dt_alias%TYPE)
203: IS
204: SELECT alias_val
205: FROM igs_ca_da_inst_v
206: WHERE cal_type = cp_fee_cal_type
207: AND ci_sequence_number = cp_fee_ci_sequence_number
208: AND dt_alias = cp_date_alias
209: ORDER BY alias_val DESC;

Line 210: l_refund_dt_val igs_ca_da_inst_v.alias_val%TYPE;

206: WHERE cal_type = cp_fee_cal_type
207: AND ci_sequence_number = cp_fee_ci_sequence_number
208: AND dt_alias = cp_date_alias
209: ORDER BY alias_val DESC;
210: l_refund_dt_val igs_ca_da_inst_v.alias_val%TYPE;
211:
212: BEGIN
213: -- If the mandatory parameters are not passed then the function returnd FALSE
214: IF (p_fee_cal_type IS NULL OR p_fee_ci_sequence_number IS NULL) THEN

Line 234: -- Get the Alias Value from the igs_ca_da_inst_v view, returns FALSE when no data found

230: IF (l_refund_dt_alias IS NULL) THEN
231: RETURN FALSE;
232: END IF;
233:
234: -- Get the Alias Value from the igs_ca_da_inst_v view, returns FALSE when no data found
235: OPEN cur_alias_val(p_fee_cal_type, p_fee_ci_sequence_number, l_refund_dt_alias);
236: FETCH cur_alias_val INTO l_refund_dt_val;
237: IF cur_alias_val%NOTFOUND THEN
238: CLOSE cur_alias_val;