APPS.IGS_FI_GEN_001 dependencies on IGS_FI_FEE_TYPE

Line 97: l_v_trigger_fired igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;

93: l_c_fcfldate c_fcfldate%ROWTYPE;
94: l_d_start_dt DATE;
95: l_d_end_dt DATE;
96: l_d_commencement_dt DATE;
97: l_v_trigger_fired igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;
98: BEGIN
99: IF (p_n_person_id IS NULL OR
100: p_v_course_cd IS NULL OR
101: p_n_course_version IS NULL OR

Line 182: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

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 )
184: RETURN VARCHAR2 AS
185: /*----------------------------------------------------------------------------
186: || Created By :

Line 532: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,

528: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
529: p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
530: p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
531: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
532: p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
533: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
534: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
535: p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
536: p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,

Line 546: FROM IGS_FI_FEE_TYPE ft

542: BEGIN
543: DECLARE
544: CURSOR c_ft IS
545: SELECT ft.s_fee_trigger_cat
546: FROM IGS_FI_FEE_TYPE ft
547: WHERE ft.FEE_TYPE = p_fee_type;
548: CURSOR c_ctft IS
549: SELECT ctft.COURSE_TYPE
550: FROM IGS_PS_TYPE_FEE_TRG ctft,

Line 653: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

649: (susa.end_dt IS NULL OR
650: TRUNC(SYSDATE) <= TRUNC(susa.end_dt)) AND
651: (susa.rqrmnts_complete_dt IS NULL OR
652: TRUNC(SYSDATE) <= TRUNC(susa.rqrmnts_complete_dt));
653: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
654: v_check CHAR(1);
655: --------------------------------------------------------------------------------
656: FUNCTION finpl_val_trig_group (p_fee_trigger_group_number
657: IGS_FI_FEE_TRG_GRP.fee_trigger_group_number%TYPE)

Line 1133: FROM IGS_FI_FEE_TYPE ft,

1129:
1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1131: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1132: SELECT SUM(fas.transaction_amount/fas.exchange_rate)
1133: FROM IGS_FI_FEE_TYPE ft,
1134: IGS_FI_FEE_AS fas
1135: WHERE ft.s_fee_type = cst_hecs AND
1136: fas.person_id = p_person_id AND
1137: fas.course_cd = p_course_cd AND

Line 1212: FROM IGS_FI_FEE_TYPE ft,

1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1211: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1212: FROM IGS_FI_FEE_TYPE ft,
1213: IGS_FI_FEE_AS fadv
1214: WHERE ft.s_fee_type = cst_hecs
1215: AND fadv.person_id = p_person_id
1216: AND ((fadv.course_cd = p_course_cd) OR ( fadv.course_cd IS NULL AND p_course_cd IS NULL))

Line 1374: FROM IGS_FI_FEE_TYPE ft,

1370:
1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1372: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1373: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1374: FROM IGS_FI_FEE_TYPE ft,
1375: IGS_FI_FEE_AS fadv
1376: WHERE ft.s_fee_type = cst_tuition
1377: AND fadv.person_id = p_person_id
1378: AND ((fadv.course_cd = p_course_cd ) OR (fadv.course_cd IS NULL AND p_course_cd IS NULL))