DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGF_GR_TUITION_FEE_CODES

Line 2104: FROM igf_gr_tuition_fee_codes ltfees,

2100: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
2101: p_sequence_number igf_gr_rfms_all.ci_sequence_number%TYPE)
2102: IS
2103: SELECT ltfees.lt_fees_code
2104: FROM igf_gr_tuition_fee_codes ltfees,
2105: igf_ap_batch_aw_map_all batch
2106: WHERE p_exp BETWEEN ltfees.min_range_amt AND ltfees.max_range_amt
2107: AND batch.ci_cal_type = p_cal_type
2108: AND batch.ci_sequence_number = p_sequence_number

Line 2113: lv_fees_code igf_gr_tuition_fee_codes.lt_fees_code%TYPE;

2109: AND batch.sys_award_year = ltfees.sys_awd_yr;
2110:
2111: tufees_code_rec cur_tufees_code%ROWTYPE;
2112:
2113: lv_fees_code igf_gr_tuition_fee_codes.lt_fees_code%TYPE;
2114:
2115: BEGIN
2116:
2117: OPEN cur_get_award (p_base_id);