DBA Data[Home] [Help]

APPS.IGF_AP_EFC_SUBF dependencies on IGF_FC_INC_PRCT

Line 139: FROM igf_fc_inc_prct ipa

135: -- Cursor to calculate Income Protection Allowance
136: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,
137: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS
138: SELECT ip_allowance_amt
139: FROM igf_fc_inc_prct ipa
140: WHERE ipa.table_code = 'A3'
141: AND ipa.s_award_year = igf_ap_efc_calc.p_sys_award_year
142: AND ipa.people_in_household = cp_num_family_member
143: AND ipa.students_in_household = cp_num_in_college ;

Line 2211: FROM igf_fc_inc_prct ipa

2207: -- Cursor to calculate Income Protection Allowance(Use of table C3 )
2208: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,
2209: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS
2210: SELECT ip_allowance_amt
2211: FROM igf_fc_inc_prct ipa
2212: WHERE ipa.table_code = 'C3'
2213: AND ipa.people_in_household = cp_num_family_member
2214: AND ipa.students_in_household = cp_num_in_college
2215: AND ipa.s_award_year = igf_ap_efc_calc.p_sys_award_year;