DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_FI_FEE_CAT

Line 133: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,

129:
130: -- Routine to rollover fee type calendar instances between cal instances
131: FUNCTION finp_ins_roll_ftci(
132: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
133: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
134: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
135: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
136: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
137: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 646: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,

642: --
643: -- Routine to rollover fee type calendar instances between cal instances
644: FUNCTION finp_ins_roll_ftci(
645: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
646: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
647: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
648: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
649: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
650: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 1230: IGS_FI_FEE_CAT fc

1226: fcci.retro_dt_alias,
1227: fcci.retro_dai_sequence_number
1228: FROM IGS_FI_F_CAT_CA_INST fcci,
1229: IGS_FI_FEE_STR_STAT fss,
1230: IGS_FI_FEE_CAT fc
1231: WHERE (p_fee_cat IS NULL OR
1232: fcci.fee_cat = p_fee_cat) AND
1233: fcci.fee_cal_type = p_source_cal_type AND
1234: fcci.fee_ci_sequence_number = p_source_sequence_number AND