APPS.IGS_FI_GEN_001 dependencies on IGS_FI_FEE_CAT

Line 183: p_fee_category IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE )

179: p_fee_cal_type IN IGS_CA_TYPE.CAL_TYPE%TYPE ,
180: p_fee_ci_sequence_num IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ,
181: p_s_relation_type IN VARCHAR2,
182: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
183: p_fee_category IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE )
184: RETURN VARCHAR2 AS
185: /*----------------------------------------------------------------------------
186: || Created By :
187: || Created On :

Line 206: CURSOR c_fc (cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS

202: SELECT currency_cd
203: FROM igs_fi_control;
204:
205: --Cursor to fetch the currency code value for a fee category
206: CURSOR c_fc (cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
207: SELECT currency_cd
208: FROM IGS_FI_FEE_CAT fc
209: WHERE FEE_CAT = cp_fee_cat;
210: -- this cursor finds the relation type value for a fee ass rate

Line 208: FROM IGS_FI_FEE_CAT fc

204:
205: --Cursor to fetch the currency code value for a fee category
206: CURSOR c_fc (cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
207: SELECT currency_cd
208: FROM IGS_FI_FEE_CAT fc
209: WHERE FEE_CAT = cp_fee_cat;
210: -- this cursor finds the relation type value for a fee ass rate
211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

Line 215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS

211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
213: cp_fee_ci_seq_num
214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
216: SELECT DISTINCT
217: s_relation_type
218: FROM IGS_FI_FEE_AS_RATE
219: WHERE FEE_TYPE = cp_fee_type AND

Line 943: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,

939: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
940: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
941: p_s_relation_type IN VARCHAR2 ,
942: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
943: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
944: p_schedule_number IN NUMBER,
945: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
946: p_dai_sequence_num IN NUMBER )
947: RETURN DATE AS

Line 960: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,

956: p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
957: p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
958: p_s_relation_type IN VARCHAR2 ,
959: p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
960: p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
961: p_schedule_number IN NUMBER,
962: p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
963: p_dai_sequence_num IN NUMBER )
964: RETURN DATE AS