APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_FEE_STR_STAT

Line 846: igs_fi_fee_str_stat fss

842: --to get fee related info based on the prameters value passed
843: CURSOR c_fee_type IS
844: SELECT fcc.fee_cal_type
845: FROM igs_fi_f_typ_ca_inst fcc,
846: igs_fi_fee_str_stat fss
847: WHERE fcc.fee_type_ci_status = fss.fee_structure_status
848: AND fss.s_fee_structure_status = 'ACTIVE'
849: AND fcc.fee_cal_type = p_fee_cal_type
850: AND fcc.fee_ci_sequence_number = p_fee_ci_sequence_number ;