[Home] [Help]
175: END check_stdnt_prg_att_liable;
176:
177:
178: FUNCTION finp_get_currency(
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 )
1440: Who When What
1441: ******************************************************************/
1442: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1443: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1444: p_cal_category IN igs_ca_type.s_cal_cat%TYPE,
1445: p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1446: p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1447: p_message_name OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE)
1448: RETURN BOOLEAN AS
1454: sub_ci_sequence_number,
1455: sup_cal_type,
1456: sup_ci_sequence_number
1457: FROM igs_ca_inst_rel cir,
1458: igs_ca_type ct1,
1459: igs_ca_type ct2
1460: WHERE cir.sub_cal_type = ct1.cal_type
1461: AND cir.sup_cal_type = ct2.cal_type
1462: AND ct1.s_cal_cat IN ('LOAD','FEE')
1455: sup_cal_type,
1456: sup_ci_sequence_number
1457: FROM igs_ca_inst_rel cir,
1458: igs_ca_type ct1,
1459: igs_ca_type ct2
1460: WHERE cir.sub_cal_type = ct1.cal_type
1461: AND cir.sup_cal_type = ct2.cal_type
1462: AND ct1.s_cal_cat IN ('LOAD','FEE')
1463: AND ct2.s_cal_cat IN ('LOAD','FEE')
1512: Who When What
1513: ******************************************************************/
1514: p_cal_type IN igs_ca_inst.cal_type%TYPE,
1515: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1516: p_cal_category IN igs_ca_type.s_cal_cat%TYPE)
1517: RETURN VARCHAR2 AS
1518:
1519: l_cal_type igs_ca_inst.cal_type%TYPE;
1520: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;