DBA Data[Home] [Help]

APPS.IGS_FI_REFUNDS_PROCESS dependencies on IGS_CA_INST

Line 117: sapanigr 14-Feb-2006 Bug#5018036 - 1. Cursor cur_date modified to use igs_fi_f_typ_ca_inst_all and igs_ca_inst

113:
114: Known limitations,enhancements,remarks:
115: Change History
116: Who When What
117: sapanigr 14-Feb-2006 Bug#5018036 - 1. Cursor cur_date modified to use igs_fi_f_typ_ca_inst_all and igs_ca_inst
118: instead of igs_fi_f_typ_ca_inst_lkp_v
119: 2. Cursor cur_pers changed to query hz_parties instead of igs_fi_parties_v
120:
121: ********************************************************************************************** */

Line 137: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci

133: l_cur_inv cur_inv%ROWTYPE;
134:
135: CURSOR cur_date IS
136: SELECT ci.start_dt start_dt,ci.end_dt end_dt
137: FROM igs_fi_f_typ_ca_inst_all ftci, igs_ca_inst ci
138: WHERE ftci.fee_type=p_fee_type
139: AND ftci.fee_cal_type=p_fee_cal_type
140: AND ftci.fee_ci_sequence_number=p_sequence_number
141: AND ci.cal_type = ftci.fee_cal_type