DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FIN_LT_CHG dependencies on IGS_FI_FEE_STR_STAT

Line 208: igs_fi_fee_str_stat fss

204: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS
205: SELECT 'X'
206: FROM igs_fi_f_typ_ca_inst_all fcc,
207: -- bug 5018036: Changed igs_fi_f_typ_ca_inst_lkp_v to igs_fi_f_typ_ca_inst_all
208: igs_fi_fee_str_stat fss
209: WHERE fcc.fee_type = cp_fee_type
210: AND fcc.fee_cal_type = cp_fee_cal_type
211: AND fcc.fee_ci_sequence_number = cp_fee_ci_sequence_number
212: AND fcc.fee_type_ci_status = fss.fee_structure_status