APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_CA_INST

Line 97: igs_ca_inst ci,

93: ci.cal_type,
94: ci.sequence_number
95: FROM igs_fi_fee_type ft,
96: igs_fi_f_typ_ca_inst ftci,
97: igs_ca_inst ci,
98: igs_fi_fee_str_stat fsst
99: WHERE ft.fee_type = ftci.fee_type
100: AND ft.s_fee_type = g_refund
101: AND ci.cal_type = ftci.fee_cal_type

Line 200: CURSOR cur_alias_val (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,

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)
203: IS
204: SELECT alias_val

Line 201: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

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)
203: IS
204: SELECT alias_val
205: FROM igs_ca_da_inst_v