eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_FEE_AS_RT

Line 1525: v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;

1521: DECLARE
1522: e_one_record_expected EXCEPTION;
1523: v_message_name VARCHAR2(30);
1524: v_charge_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE := 0.0;
1525: v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
1526: v_residency_status_cd igs_fi_fee_as_rate.residency_status_cd%TYPE;
1527: v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
1528: v_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
1529: v_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE;

Line 1528: v_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;

1524: v_charge_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE := 0.0;
1525: v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
1526: v_residency_status_cd igs_fi_fee_as_rate.residency_status_cd%TYPE;
1527: v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
1528: v_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
1529: v_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE;
1530: v_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE;
1531: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1532: l_v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE;

Line 1639: FROM igs_fi_fee_as_rt cfar,

1635: cp_prog_att_mode igs_fi_fee_as_rate.attendance_mode%TYPE,
1636: cp_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE) IS
1637: SELECT cfar.lower_nrml_rate_ovrd_ind,
1638: cfar.chg_rate
1639: FROM igs_fi_fee_as_rt cfar,
1640: igs_en_atd_mode_all am
1641: WHERE cfar.person_id = p_person_id AND
1642: cfar.course_cd = p_course_cd AND
1643: cfar.FEE_TYPE = p_fee_type AND

Line 2917: l_v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;

2913: l_n_count NUMBER; -- Used like an index variable when a new record in added to the plsql table tbl_fai_unit_dtls
2914: l_v_party_number hz_parties.party_number%TYPE := NULL;
2915: l_n_loop_subelm_rng NUMBER;
2916: l_n_previous_upper igs_fi_sub_elm_rng.sub_upper_range%TYPE;
2917: l_v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
2918: l_n_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
2919: lv_cntrct_rt_apply BOOLEAN;
2920: l_n_summed_chg_elm igs_fi_fee_as_items.chg_elements%TYPE;
2921: l_n_rate_factor igs_fi_fee_as_items.chg_elements%TYPE;

Line 2918: l_n_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;

2914: l_v_party_number hz_parties.party_number%TYPE := NULL;
2915: l_n_loop_subelm_rng NUMBER;
2916: l_n_previous_upper igs_fi_sub_elm_rng.sub_upper_range%TYPE;
2917: l_v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
2918: l_n_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
2919: lv_cntrct_rt_apply BOOLEAN;
2920: l_n_summed_chg_elm igs_fi_fee_as_items.chg_elements%TYPE;
2921: l_n_rate_factor igs_fi_fee_as_items.chg_elements%TYPE;
2922: l_b_flag BOOLEAN;