DBA Data[Home] [Help]

APPS.IGS_FI_PRC_IMPCLC_ANC_CHGS dependencies on IGS_FI_FEE_STR_STAT

Line 249: FROM igs_fi_f_typ_ca_inst ftci, igs_fi_fee_str_stat fss

245: CURSOR cur_ftci(cp_cal_type igs_fi_anc_rates.Fee_Cal_Type%TYPE,
246: cp_ci_sequence_number igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
247: cp_fee_type igs_fi_anc_rates.Fee_Type%TYPE) IS
248: SELECT 'x'
249: FROM igs_fi_f_typ_ca_inst ftci, igs_fi_fee_str_stat fss
250: WHERE ftci.fee_cal_type = cp_cal_type
251: AND ftci.fee_ci_sequence_number = cp_ci_sequence_number
252: AND ftci.fee_type = cp_fee_type
253: AND fss.fee_structure_status = ftci.fee_type_ci_status