[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party_number
FROM hz_parties parties,
igf_ap_fa_base_rec_all fabase
WHERE fabase.person_id = parties.party_id
AND fabase.base_id = cp_base_id;
SELECT alternate_code
FROM igs_ca_inst_all
WHERE cal_type = cp_cal_type
AND sequence_number = cp_seq_number;
SELECT group_cd group_name
FROM igs_pe_persid_group_all
WHERE group_id = cp_persid_grp;
SELECT prof.*
FROM igf_ap_css_profile prof
WHERE base_id = cp_base_id;
SELECT fnar.*
FROM igf_ap_css_fnar fnar
WHERE cssp_id = cp_cssp_id;
SELECT sys_award_year
FROM igf_ap_batch_aw_map_all
WHERE ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_seq_number;
fnd_message.set_name('IGF','IGF_AP_PROF_UHK_UPDATED_PK');
igf_ap_css_profile_pkg.update_row(
x_rowid => l_profile.row_id,
x_cssp_id => l_profile.cssp_id,
x_base_id => l_profile.base_id,
x_system_record_type => l_profile.system_record_type,
x_active_profile => l_profile.active_profile,
x_college_code => l_profile.college_code,
x_academic_year => l_profile.academic_year,
x_stu_record_type => l_profile.stu_record_type,
x_css_id_number => l_profile.css_id_number,
x_registration_receipt_date => l_profile.registration_receipt_date,
x_registration_type => l_profile.registration_type,
x_application_receipt_date => l_profile.application_receipt_date,
x_application_type => l_profile.application_type,
x_original_fnar_compute => l_profile.original_fnar_compute,
x_revision_fnar_compute_date => l_profile.revision_fnar_compute_date,
x_electronic_extract_date => l_profile.electronic_extract_date,
x_institutional_reporting_type => l_profile.institutional_reporting_type,
x_asr_receipt_date => l_profile.asr_receipt_date,
x_last_name => l_profile.last_name,
x_first_name => l_profile.first_name,
x_middle_initial => l_profile.middle_initial,
x_address_number_and_street => l_profile.address_number_and_street,
x_city => l_profile.city,
x_state_mailing => l_profile.state_mailing,
x_zip_code => l_profile.zip_code,
x_s_telephone_number => l_profile.s_telephone_number,
x_s_title => l_profile.s_title,
x_date_of_birth => l_profile.date_of_birth,
x_social_security_number => l_profile.social_security_number,
x_state_legal_residence => l_profile.state_legal_residence,
x_foreign_address_indicator => l_profile.foreign_address_indicator,
x_foreign_postal_code => l_profile.foreign_postal_code,
x_country => l_profile.country,
x_financial_aid_status => l_profile.financial_aid_status,
x_year_in_college => l_profile.year_in_college,
x_marital_status => l_profile.marital_status,
x_ward_court => l_profile.ward_court,
x_legal_dependents_other => l_profile.legal_dependents_other,
x_household_size => l_profile.household_size,
x_number_in_college => l_profile.number_in_college,
x_citizenship_status => l_profile.citizenship_status,
x_citizenship_country => l_profile.citizenship_country,
x_visa_classification => l_profile.visa_classification,
x_tax_figures => l_profile.tax_figures,
x_number_exemptions => l_profile.number_exemptions,
x_adjusted_gross_inc => l_profile.adjusted_gross_inc,
x_us_tax_paid => l_profile.us_tax_paid,
x_itemized_deductions => l_profile.itemized_deductions,
x_stu_income_work => l_profile.stu_income_work,
x_spouse_income_work => l_profile.spouse_income_work,
x_divid_int_inc => l_profile.divid_int_inc,
x_soc_sec_benefits => l_profile.soc_sec_benefits,
x_welfare_tanf => l_profile.welfare_tanf,
x_child_supp_rcvd => l_profile.child_supp_rcvd,
x_earned_income_credit => l_profile.earned_income_credit,
x_other_untax_income => l_profile.other_untax_income,
x_tax_stu_aid => l_profile.tax_stu_aid,
x_cash_sav_check => l_profile.cash_sav_check,
x_ira_keogh => l_profile.ira_keogh,
x_invest_value => l_profile.invest_value,
x_invest_debt => l_profile.invest_debt,
x_home_value => l_profile.home_value,
x_home_debt => l_profile.home_debt,
x_oth_real_value => l_profile.oth_real_value,
x_oth_real_debt => l_profile.oth_real_debt,
x_bus_farm_value => l_profile.bus_farm_value,
x_bus_farm_debt => l_profile.bus_farm_debt,
x_live_on_farm => l_profile.live_on_farm,
x_home_purch_price => l_profile.home_purch_price,
x_hope_ll_credit => l_profile.hope_ll_credit,
x_home_purch_year => l_profile.home_purch_year,
x_trust_amount => l_profile.trust_amount,
x_trust_avail => l_profile.trust_avail,
x_trust_estab => l_profile.trust_estab,
x_child_support_paid => l_profile.child_support_paid,
x_med_dent_expenses => l_profile.med_dent_expenses,
x_vet_us => l_profile.vet_us,
x_vet_ben_amount => l_profile.vet_ben_amount,
x_vet_ben_months => l_profile.vet_ben_months,
x_stu_summer_wages => l_profile.stu_summer_wages,
x_stu_school_yr_wages => l_profile.stu_school_yr_wages,
x_spouse_summer_wages => l_profile.spouse_summer_wages,
x_spouse_school_yr_wages => l_profile.spouse_school_yr_wages,
x_summer_other_tax_inc => l_profile.summer_other_tax_inc,
x_school_yr_other_tax_inc => l_profile.school_yr_other_tax_inc,
x_summer_untax_inc => l_profile.summer_untax_inc,
x_school_yr_untax_inc => l_profile.school_yr_untax_inc,
x_grants_schol_etc => l_profile.grants_schol_etc,
x_tuit_benefits => l_profile.tuit_benefits,
x_cont_parents => l_profile.cont_parents,
x_cont_relatives => l_profile.cont_relatives,
x_p_siblings_pre_tuit => l_profile.p_siblings_pre_tuit,
x_p_student_pre_tuit => l_profile.p_student_pre_tuit,
x_p_household_size => l_profile.p_household_size,
x_p_number_in_college => l_profile.p_number_in_college,
x_p_parents_in_college => l_profile.p_parents_in_college,
x_p_marital_status => l_profile.p_marital_status,
x_p_state_legal_residence => l_profile.p_state_legal_residence,
x_p_natural_par_status => l_profile.p_natural_par_status,
x_p_child_supp_paid => l_profile.p_child_supp_paid,
x_p_repay_ed_loans => l_profile.p_repay_ed_loans,
x_p_med_dent_expenses => l_profile.p_med_dent_expenses,
x_p_tuit_paid_amount => l_profile.p_tuit_paid_amount,
x_p_tuit_paid_number => l_profile.p_tuit_paid_number,
x_p_exp_child_supp_paid => l_profile.p_exp_child_supp_paid,
x_p_exp_repay_ed_loans => l_profile.p_exp_repay_ed_loans,
x_p_exp_med_dent_expenses => l_profile.p_exp_med_dent_expenses,
x_p_exp_tuit_pd_amount => l_profile.p_exp_tuit_pd_amount,
x_p_exp_tuit_pd_number => l_profile.p_exp_tuit_pd_number,
x_p_cash_sav_check => l_profile.p_cash_sav_check,
x_p_month_mortgage_pay => l_profile.p_month_mortgage_pay,
x_p_invest_value => l_profile.p_invest_value,
x_p_invest_debt => l_profile.p_invest_debt,
x_p_home_value => l_profile.p_home_value,
x_p_home_debt => l_profile.p_home_debt,
x_p_home_purch_price => l_profile.p_home_purch_price,
x_p_own_business_farm => l_profile.p_own_business_farm,
x_p_business_value => l_profile.p_business_value,
x_p_business_debt => l_profile.p_business_debt,
x_p_farm_value => l_profile.p_farm_value,
x_p_farm_debt => l_profile.p_farm_debt,
x_p_live_on_farm => l_profile.p_live_on_farm,
x_p_oth_real_estate_value => l_profile.p_oth_real_estate_value,
x_p_oth_real_estate_debt => l_profile.p_oth_real_estate_debt,
x_p_oth_real_purch_price => l_profile.p_oth_real_purch_price,
x_p_siblings_assets => l_profile.p_siblings_assets,
x_p_home_purch_year => l_profile.p_home_purch_year,
x_p_oth_real_purch_year => l_profile.p_oth_real_purch_year,
x_p_prior_agi => l_profile.p_prior_agi,
x_p_prior_us_tax_paid => l_profile.p_prior_us_tax_paid,
x_p_prior_item_deductions => l_profile.p_prior_item_deductions,
x_p_prior_other_untax_inc => l_profile.p_prior_other_untax_inc,
x_p_tax_figures => l_profile.p_tax_figures,
x_p_number_exemptions => l_profile.p_number_exemptions,
x_p_adjusted_gross_inc => l_profile.p_adjusted_gross_inc,
x_p_wages_sal_tips => l_profile.p_wages_sal_tips,
x_p_interest_income => l_profile.p_interest_income,
x_p_dividend_income => l_profile.p_dividend_income,
x_p_net_inc_bus_farm => l_profile.p_net_inc_bus_farm,
x_p_other_taxable_income => l_profile.p_other_taxable_income,
x_p_adj_to_income => l_profile.p_adj_to_income,
x_p_us_tax_paid => l_profile.p_us_tax_paid,
x_p_itemized_deductions => l_profile.p_itemized_deductions,
x_p_father_income_work => l_profile.p_father_income_work,
x_p_mother_income_work => l_profile.p_mother_income_work,
x_p_soc_sec_ben => l_profile.p_soc_sec_ben,
x_p_welfare_tanf => l_profile.p_welfare_tanf,
x_p_child_supp_rcvd => l_profile.p_child_supp_rcvd,
x_p_ded_ira_keogh => l_profile.p_ded_ira_keogh,
x_p_tax_defer_pens_savs => l_profile.p_tax_defer_pens_savs,
x_p_dep_care_med_spending => l_profile.p_dep_care_med_spending,
x_p_earned_income_credit => l_profile.p_earned_income_credit,
x_p_living_allow => l_profile.p_living_allow,
x_p_tax_exmpt_int => l_profile.p_tax_exmpt_int,
x_p_foreign_inc_excl => l_profile.p_foreign_inc_excl,
x_p_other_untax_inc => l_profile.p_other_untax_inc,
x_p_hope_ll_credit => l_profile.p_hope_ll_credit,
x_p_yr_separation => l_profile.p_yr_separation,
x_p_yr_divorce => l_profile.p_yr_divorce,
x_p_exp_father_inc => l_profile.p_exp_father_inc,
x_p_exp_mother_inc => l_profile.p_exp_mother_inc,
x_p_exp_other_tax_inc => l_profile.p_exp_other_tax_inc,
x_p_exp_other_untax_inc => l_profile.p_exp_other_untax_inc,
x_line_2_relation => l_profile.line_2_relation,
x_line_2_attend_college => l_profile.line_2_attend_college,
x_line_3_relation => l_profile.line_3_relation,
x_line_3_attend_college => l_profile.line_3_attend_college,
x_line_4_relation => l_profile.line_4_relation,
x_line_4_attend_college => l_profile.line_4_attend_college,
x_line_5_relation => l_profile.line_5_relation,
x_line_5_attend_college => l_profile.line_5_attend_college,
x_line_6_relation => l_profile.line_6_relation,
x_line_6_attend_college => l_profile.line_6_attend_college,
x_line_7_relation => l_profile.line_7_relation,
x_line_7_attend_college => l_profile.line_7_attend_college,
x_line_8_relation => l_profile.line_8_relation,
x_line_8_attend_college => l_profile.line_8_attend_college,
x_p_age_father => l_profile.p_age_father,
x_p_age_mother => l_profile.p_age_mother,
x_p_div_sep_ind => l_profile.p_div_sep_ind,
x_b_cont_non_custodial_par => l_profile.b_cont_non_custodial_par,
x_college_type_2 => l_profile.college_type_2,
x_college_type_3 => l_profile.college_type_3,
x_college_type_4 => l_profile.college_type_4,
x_college_type_5 => l_profile.college_type_5,
x_college_type_6 => l_profile.college_type_6,
x_college_type_7 => l_profile.college_type_7,
x_college_type_8 => l_profile.college_type_8,
x_school_code_1 => l_profile.school_code_1,
x_housing_code_1 => l_profile.housing_code_1,
x_school_code_2 => l_profile.school_code_2,
x_housing_code_2 => l_profile.housing_code_2,
x_school_code_3 => l_profile.school_code_3,
x_housing_code_3 => l_profile.housing_code_3,
x_school_code_4 => l_profile.school_code_4,
x_housing_code_4 => l_profile.housing_code_4,
x_school_code_5 => l_profile.school_code_5,
x_housing_code_5 => l_profile.housing_code_5,
x_school_code_6 => l_profile.school_code_6,
x_housing_code_6 => l_profile.housing_code_6,
x_school_code_7 => l_profile.school_code_7,
x_housing_code_7 => l_profile.housing_code_7,
x_school_code_8 => l_profile.school_code_8,
x_housing_code_8 => l_profile.housing_code_8,
x_school_code_9 => l_profile.school_code_9,
x_housing_code_9 => l_profile.housing_code_9,
x_school_code_10 => l_profile.school_code_10,
x_housing_code_10 => l_profile.housing_code_10,
x_additional_school_code_1 => l_profile.additional_school_code_1,
x_additional_school_code_2 => l_profile.additional_school_code_2,
x_additional_school_code_3 => l_profile.additional_school_code_3,
x_additional_school_code_4 => l_profile.additional_school_code_4,
x_additional_school_code_5 => l_profile.additional_school_code_5,
x_additional_school_code_6 => l_profile.additional_school_code_6,
x_additional_school_code_7 => l_profile.additional_school_code_7,
x_additional_school_code_8 => l_profile.additional_school_code_8,
x_additional_school_code_9 => l_profile.additional_school_code_9,
x_additional_school_code_10 => l_profile.additional_school_code_10,
x_explanation_spec_circum => l_profile.explanation_spec_circum,
x_signature_student => l_profile.signature_student,
x_signature_spouse => l_profile.signature_spouse,
x_signature_father => l_profile.signature_father,
x_signature_mother => l_profile.signature_mother,
x_month_day_completed => l_profile.month_day_completed,
x_year_completed => l_profile.year_completed,
x_age_line_2 => l_profile.age_line_2,
x_age_line_3 => l_profile.age_line_3,
x_age_line_4 => l_profile.age_line_4,
x_age_line_5 => l_profile.age_line_5,
x_age_line_6 => l_profile.age_line_6,
x_age_line_7 => l_profile.age_line_7,
x_age_line_8 => l_profile.age_line_8,
x_a_online_signature => l_profile.a_online_signature,
x_question_1_number => l_profile.question_1_number,
x_question_1_size => l_profile.question_1_size,
x_question_1_answer => l_profile.question_1_answer,
x_question_2_number => l_profile.question_2_number,
x_question_2_size => l_profile.question_2_size,
x_question_2_answer => l_profile.question_2_answer,
x_question_3_number => l_profile.question_3_number,
x_question_3_size => l_profile.question_3_size,
x_question_3_answer => l_profile.question_3_answer,
x_question_4_number => l_profile.question_4_number,
x_question_4_size => l_profile.question_4_size,
x_question_4_answer => l_profile.question_4_answer,
x_question_5_number => l_profile.question_5_number,
x_question_5_size => l_profile.question_5_size,
x_question_5_answer => l_profile.question_5_answer,
x_question_6_number => l_profile.question_6_number,
x_question_6_size => l_profile.question_6_size,
x_question_6_answer => l_profile.question_6_answer,
x_question_7_number => l_profile.question_7_number,
x_question_7_size => l_profile.question_7_size,
x_question_7_answer => l_profile.question_7_answer,
x_question_8_number => l_profile.question_8_number,
x_question_8_size => l_profile.question_8_size,
x_question_8_answer => l_profile.question_8_answer,
x_question_9_number => l_profile.question_9_number,
x_question_9_size => l_profile.question_9_size,
x_question_9_answer => l_profile.question_9_answer,
x_question_10_number => l_profile.question_10_number,
x_question_10_size => l_profile.question_10_size,
x_question_10_answer => l_profile.question_10_answer,
x_question_11_number => l_profile.question_11_number,
x_question_11_size => l_profile.question_11_size,
x_question_11_answer => l_profile.question_11_answer,
x_question_12_number => l_profile.question_12_number,
x_question_12_size => l_profile.question_12_size,
x_question_12_answer => l_profile.question_12_answer,
x_question_13_number => l_profile.question_13_number,
x_question_13_size => l_profile.question_13_size,
x_question_13_answer => l_profile.question_13_answer,
x_question_14_number => l_profile.question_14_number,
x_question_14_size => l_profile.question_14_size,
x_question_14_answer => l_profile.question_14_answer,
x_question_15_number => l_profile.question_15_number,
x_question_15_size => l_profile.question_15_size,
x_question_15_answer => l_profile.question_15_answer,
x_question_16_number => l_profile.question_16_number,
x_question_16_size => l_profile.question_16_size,
x_question_16_answer => l_profile.question_16_answer,
x_question_17_number => l_profile.question_17_number,
x_question_17_size => l_profile.question_17_size,
x_question_17_answer => l_profile.question_17_answer,
x_question_18_number => l_profile.question_18_number,
x_question_18_size => l_profile.question_18_size,
x_question_18_answer => l_profile.question_18_answer,
x_question_19_number => l_profile.question_19_number,
x_question_19_size => l_profile.question_19_size,
x_question_19_answer => l_profile.question_19_answer,
x_question_20_number => l_profile.question_20_number,
x_question_20_size => l_profile.question_20_size,
x_question_20_answer => l_profile.question_20_answer,
x_question_21_number => l_profile.question_21_number,
x_question_21_size => l_profile.question_21_size,
x_question_21_answer => l_profile.question_21_answer,
x_question_22_number => l_profile.question_22_number,
x_question_22_size => l_profile.question_22_size,
x_question_22_answer => l_profile.question_22_answer,
x_question_23_number => l_profile.question_23_number,
x_question_23_size => l_profile.question_23_size,
x_question_23_answer => l_profile.question_23_answer,
x_question_24_number => l_profile.question_24_number,
x_question_24_size => l_profile.question_24_size,
x_question_24_answer => l_profile.question_24_answer,
x_question_25_number => l_profile.question_25_number,
x_question_25_size => l_profile.question_25_size,
x_question_25_answer => l_profile.question_25_answer,
x_question_26_number => l_profile.question_26_number,
x_question_26_size => l_profile.question_26_size,
x_question_26_answer => l_profile.question_26_answer,
x_question_27_number => l_profile.question_27_number,
x_question_27_size => l_profile.question_27_size,
x_question_27_answer => l_profile.question_27_answer,
x_question_28_number => l_profile.question_28_number,
x_question_28_size => l_profile.question_28_size,
x_question_28_answer => l_profile.question_28_answer,
x_question_29_number => l_profile.question_29_number,
x_question_29_size => l_profile.question_29_size,
x_question_29_answer => l_profile.question_29_answer,
x_question_30_number => l_profile.question_30_number,
x_questions_30_size => l_profile.questions_30_size,
x_question_30_answer => l_profile.question_30_answer,
x_mode => 'R',
x_legacy_record_flag => l_profile.legacy_record_flag,
x_coa_duration_efc_amt => l_coa_duration_efc_amt,
x_coa_duration_num => l_efc_duration,
x_p_soc_sec_ben_student_amt => l_profile.p_soc_sec_ben_student_amt,
x_p_tuit_fee_deduct_amt => l_profile.p_tuit_fee_deduct_amt,
x_stu_lives_with_num => l_profile.stu_lives_with_num,
x_stu_most_support_from_num => l_profile.stu_most_support_from_num,
x_location_computer_num => l_profile.location_computer_num
);
igf_ap_css_fnar_pkg.update_row(
x_rowid => l_fnar.row_id,
x_fnar_id => l_fnar.fnar_id,
x_cssp_id => l_fnar.cssp_id,
x_r_s_email_address => l_fnar.r_s_email_address,
x_eps_code => l_fnar.eps_code,
x_comp_css_dependency_status => l_fnar.comp_css_dependency_status,
x_stu_age => l_fnar.stu_age,
x_assumed_stu_yr_in_coll => l_fnar.assumed_stu_yr_in_coll,
x_comp_stu_marital_status => l_fnar.comp_stu_marital_status,
x_stu_family_members => l_fnar.stu_family_members,
x_stu_fam_members_in_college => l_fnar.stu_fam_members_in_college,
x_par_marital_status => l_fnar.par_marital_status,
x_par_family_members => l_fnar.par_family_members,
x_par_total_in_college => l_fnar.par_total_in_college,
x_par_par_in_college => l_fnar.par_par_in_college,
x_par_others_in_college => l_fnar.par_others_in_college,
x_par_aesa => l_fnar.par_aesa,
x_par_cesa => l_fnar.par_cesa,
x_stu_aesa => l_fnar.stu_aesa,
x_stu_cesa => l_fnar.stu_cesa,
x_im_p_bas_agi_taxable_income => l_fnar.im_p_bas_agi_taxable_income,
x_im_p_bas_untx_inc_and_ben => l_fnar.im_p_bas_untx_inc_and_ben,
x_im_p_bas_inc_adj => l_fnar.im_p_bas_inc_adj,
x_im_p_bas_total_income => l_fnar.im_p_bas_total_income,
x_im_p_bas_us_income_tax => l_fnar.im_p_bas_us_income_tax,
x_im_p_bas_st_and_other_tax => l_fnar.im_p_bas_st_and_other_tax,
x_im_p_bas_fica_tax => l_fnar.im_p_bas_fica_tax,
x_im_p_bas_med_dental => l_fnar.im_p_bas_med_dental,
x_im_p_bas_employment_allow => l_fnar.im_p_bas_employment_allow,
x_im_p_bas_annual_ed_savings => l_fnar.im_p_bas_annual_ed_savings,
x_im_p_bas_inc_prot_allow_m => l_fnar.im_p_bas_inc_prot_allow_m,
x_im_p_bas_total_inc_allow => l_fnar.im_p_bas_total_inc_allow,
x_im_p_bas_cal_avail_inc => l_fnar.im_p_bas_cal_avail_inc,
x_im_p_bas_avail_income => l_fnar.im_p_bas_avail_income,
x_im_p_bas_total_cont_inc => l_fnar.im_p_bas_total_cont_inc,
x_im_p_bas_cash_bank_accounts => l_fnar.im_p_bas_cash_bank_accounts,
x_im_p_bas_home_equity => l_fnar.im_p_bas_home_equity,
x_im_p_bas_ot_rl_est_inv_eq => l_fnar.im_p_bas_ot_rl_est_inv_eq,
x_im_p_bas_adj_bus_farm_worth => l_fnar.im_p_bas_adj_bus_farm_worth,
x_im_p_bas_ass_sibs_pre_tui => l_fnar.im_p_bas_ass_sibs_pre_tui,
x_im_p_bas_net_worth => l_fnar.im_p_bas_net_worth,
x_im_p_bas_emerg_res_allow => l_fnar.im_p_bas_emerg_res_allow,
x_im_p_bas_cum_ed_savings => l_fnar.im_p_bas_cum_ed_savings,
x_im_p_bas_low_inc_allow => l_fnar.im_p_bas_low_inc_allow,
x_im_p_bas_total_asset_allow => l_fnar.im_p_bas_total_asset_allow,
x_im_p_bas_disc_net_worth => l_fnar.im_p_bas_disc_net_worth,
x_im_p_bas_total_cont_asset => l_fnar.im_p_bas_total_cont_asset,
x_im_p_bas_total_cont => l_fnar.im_p_bas_total_cont,
x_im_p_bas_num_in_coll_adj => l_fnar.im_p_bas_num_in_coll_adj,
x_im_p_bas_cont_for_stu => l_fnar.im_p_bas_cont_for_stu,
x_im_p_bas_cont_from_income => l_fnar.im_p_bas_cont_from_income,
x_im_p_bas_cont_from_assets => l_fnar.im_p_bas_cont_from_assets,
x_im_p_opt_agi_taxable_income => l_fnar.im_p_opt_agi_taxable_income,
x_im_p_opt_untx_inc_and_ben => l_fnar.im_p_opt_untx_inc_and_ben,
x_im_p_opt_inc_adj => l_fnar.im_p_opt_inc_adj,
x_im_p_opt_total_income => l_fnar.im_p_opt_total_income,
x_im_p_opt_us_income_tax => l_fnar.im_p_opt_us_income_tax,
x_im_p_opt_st_and_other_tax => l_fnar.im_p_opt_st_and_other_tax,
x_im_p_opt_fica_tax => l_fnar.im_p_opt_fica_tax,
x_im_p_opt_med_dental => l_fnar.im_p_opt_med_dental,
x_im_p_opt_elem_sec_tuit => l_fnar.im_p_opt_elem_sec_tuit,
x_im_p_opt_employment_allow => l_fnar.im_p_opt_employment_allow,
x_im_p_opt_annual_ed_savings => l_fnar.im_p_opt_annual_ed_savings,
x_im_p_opt_inc_prot_allow_m => l_fnar.im_p_opt_inc_prot_allow_m,
x_im_p_opt_total_inc_allow => l_fnar.im_p_opt_total_inc_allow,
x_im_p_opt_cal_avail_inc => l_fnar.im_p_opt_cal_avail_inc,
x_im_p_opt_avail_income => l_fnar.im_p_opt_avail_income,
x_im_p_opt_total_cont_inc => l_fnar.im_p_opt_total_cont_inc,
x_im_p_opt_cash_bank_accounts => l_fnar.im_p_opt_cash_bank_accounts,
x_im_p_opt_home_equity => l_fnar.im_p_opt_home_equity,
x_im_p_opt_ot_rl_est_inv_eq => l_fnar.im_p_opt_ot_rl_est_inv_eq,
x_im_p_opt_adj_bus_farm_worth => l_fnar.im_p_opt_adj_bus_farm_worth,
x_im_p_opt_ass_sibs_pre_tui => l_fnar.im_p_opt_ass_sibs_pre_tui,
x_im_p_opt_net_worth => l_fnar.im_p_opt_net_worth,
x_im_p_opt_emerg_res_allow => l_fnar.im_p_opt_emerg_res_allow,
x_im_p_opt_cum_ed_savings => l_fnar.im_p_opt_cum_ed_savings,
x_im_p_opt_low_inc_allow => l_fnar.im_p_opt_low_inc_allow,
x_im_p_opt_total_asset_allow => l_fnar.im_p_opt_total_asset_allow,
x_im_p_opt_disc_net_worth => l_fnar.im_p_opt_disc_net_worth,
x_im_p_opt_total_cont_asset => l_fnar.im_p_opt_total_cont_asset,
x_im_p_opt_total_cont => l_fnar.im_p_opt_total_cont,
x_im_p_opt_num_in_coll_adj => l_fnar.im_p_opt_num_in_coll_adj,
x_im_p_opt_cont_for_stu => l_fnar.im_p_opt_cont_for_stu,
x_im_p_opt_cont_from_income => l_fnar.im_p_opt_cont_from_income,
x_im_p_opt_cont_from_assets => l_fnar.im_p_opt_cont_from_assets,
x_fm_p_analysis_type => l_fnar.fm_p_analysis_type,
x_fm_p_agi_taxable_income => l_fnar.fm_p_agi_taxable_income,
x_fm_p_untx_inc_and_ben => l_fnar.fm_p_untx_inc_and_ben,
x_fm_p_inc_adj => l_fnar.fm_p_inc_adj,
x_fm_p_total_income => l_fnar.fm_p_total_income,
x_fm_p_us_income_tax => l_fnar.fm_p_us_income_tax,
x_fm_p_state_and_other_taxes => l_fnar.fm_p_state_and_other_taxes,
x_fm_p_fica_tax => l_fnar.fm_p_fica_tax,
x_fm_p_employment_allow => l_fnar.fm_p_employment_allow,
x_fm_p_income_prot_allow => l_fnar.fm_p_income_prot_allow,
x_fm_p_total_allow => l_fnar.fm_p_total_allow,
x_fm_p_avail_income => l_fnar.fm_p_avail_income,
x_fm_p_cash_bank_accounts => l_fnar.fm_p_cash_bank_accounts,
x_fm_p_ot_rl_est_inv_equity => l_fnar.fm_p_ot_rl_est_inv_equity,
x_fm_p_adj_bus_farm_net_worth => l_fnar.fm_p_adj_bus_farm_net_worth,
x_fm_p_net_worth => l_fnar.fm_p_net_worth,
x_fm_p_asset_prot_allow => l_fnar.fm_p_asset_prot_allow,
x_fm_p_disc_net_worth => l_fnar.fm_p_disc_net_worth,
x_fm_p_total_contribution => l_fnar.fm_p_total_contribution,
x_fm_p_num_in_coll => l_fnar.fm_p_num_in_coll,
x_fm_p_cont_for_stu => l_fnar.fm_p_cont_for_stu,
x_fm_p_cont_from_income => l_fnar.fm_p_cont_from_income,
x_fm_p_cont_from_assets => l_fnar.fm_p_cont_from_assets,
x_im_s_bas_agi_taxable_income => l_fnar.im_s_bas_agi_taxable_income,
x_im_s_bas_untx_inc_and_ben => l_fnar.im_s_bas_untx_inc_and_ben,
x_im_s_bas_inc_adj => l_fnar.im_s_bas_inc_adj,
x_im_s_bas_total_income => l_fnar.im_s_bas_total_income,
x_im_s_bas_us_income_tax => l_fnar.im_s_bas_us_income_tax,
x_im_s_bas_state_and_oth_taxes => l_fnar.im_s_bas_state_and_oth_taxes,
x_im_s_bas_fica_tax => l_fnar.im_s_bas_fica_tax,
x_im_s_bas_med_dental => l_fnar.im_s_bas_med_dental,
x_im_s_bas_employment_allow => l_fnar.im_s_bas_employment_allow,
x_im_s_bas_annual_ed_savings => l_fnar.im_s_bas_annual_ed_savings,
x_im_s_bas_inc_prot_allow_m => l_fnar.im_s_bas_inc_prot_allow_m,
x_im_s_bas_total_inc_allow => l_fnar.im_s_bas_total_inc_allow,
x_im_s_bas_cal_avail_income => l_fnar.im_s_bas_cal_avail_income,
x_im_s_bas_avail_income => l_fnar.im_s_bas_avail_income,
x_im_s_bas_total_cont_inc => l_fnar.im_s_bas_total_cont_inc,
x_im_s_bas_cash_bank_accounts => l_fnar.im_s_bas_cash_bank_accounts,
x_im_s_bas_home_equity => l_fnar.im_s_bas_home_equity,
x_im_s_bas_ot_rl_est_inv_eq => l_fnar.im_s_bas_ot_rl_est_inv_eq,
x_im_s_bas_adj_busfarm_worth => l_fnar.im_s_bas_adj_busfarm_worth,
x_im_s_bas_trusts => l_fnar.im_s_bas_trusts,
x_im_s_bas_net_worth => l_fnar.im_s_bas_net_worth,
x_im_s_bas_emerg_res_allow => l_fnar.im_s_bas_emerg_res_allow,
x_im_s_bas_cum_ed_savings => l_fnar.im_s_bas_cum_ed_savings,
x_im_s_bas_total_asset_allow => l_fnar.im_s_bas_total_asset_allow,
x_im_s_bas_disc_net_worth => l_fnar.im_s_bas_disc_net_worth,
x_im_s_bas_total_cont_asset => l_fnar.im_s_bas_total_cont_asset,
x_im_s_bas_total_cont => l_fnar.im_s_bas_total_cont,
x_im_s_bas_num_in_coll_adj => l_fnar.im_s_bas_num_in_coll_adj,
x_im_s_bas_cont_for_stu => l_fnar.im_s_bas_cont_for_stu,
x_im_s_bas_cont_from_income => l_fnar.im_s_bas_cont_from_income,
x_im_s_bas_cont_from_assets => l_fnar.im_s_bas_cont_from_assets,
x_im_s_est_agitaxable_income => l_fnar.im_s_est_agitaxable_income,
x_im_s_est_untx_inc_and_ben => l_fnar.im_s_est_untx_inc_and_ben,
x_im_s_est_inc_adj => l_fnar.im_s_est_inc_adj,
x_im_s_est_total_income => l_fnar.im_s_est_total_income,
x_im_s_est_us_income_tax => l_fnar.im_s_est_us_income_tax,
x_im_s_est_state_and_oth_taxes => l_fnar.im_s_est_state_and_oth_taxes,
x_im_s_est_fica_tax => l_fnar.im_s_est_fica_tax,
x_im_s_est_med_dental => l_fnar.im_s_est_med_dental,
x_im_s_est_employment_allow => l_fnar.im_s_est_employment_allow,
x_im_s_est_annual_ed_savings => l_fnar.im_s_est_annual_ed_savings,
x_im_s_est_inc_prot_allow_m => l_fnar.im_s_est_inc_prot_allow_m,
x_im_s_est_total_inc_allow => l_fnar.im_s_est_total_inc_allow,
x_im_s_est_cal_avail_income => l_fnar.im_s_est_cal_avail_income,
x_im_s_est_avail_income => l_fnar.im_s_est_avail_income,
x_im_s_est_total_cont_inc => l_fnar.im_s_est_total_cont_inc,
x_im_s_est_cash_bank_accounts => l_fnar.im_s_est_cash_bank_accounts,
x_im_s_est_home_equity => l_fnar.im_s_est_home_equity,
x_im_s_est_ot_rl_est_inv_eq => l_fnar.im_s_est_ot_rl_est_inv_eq,
x_im_s_est_adj_bus_farm_worth => l_fnar.im_s_est_adj_bus_farm_worth,
x_im_s_est_est_trusts => l_fnar.im_s_est_est_trusts,
x_im_s_est_net_worth => l_fnar.im_s_est_net_worth,
x_im_s_est_emerg_res_allow => l_fnar.im_s_est_emerg_res_allow,
x_im_s_est_cum_ed_savings => l_fnar.im_s_est_cum_ed_savings,
x_im_s_est_total_asset_allow => l_fnar.im_s_est_total_asset_allow,
x_im_s_est_disc_net_worth => l_fnar.im_s_est_disc_net_worth,
x_im_s_est_total_cont_asset => l_fnar.im_s_est_total_cont_asset,
x_im_s_est_total_cont => l_fnar.im_s_est_total_cont,
x_im_s_est_num_in_coll_adj => l_fnar.im_s_est_num_in_coll_adj,
x_im_s_est_cont_for_stu => l_fnar.im_s_est_cont_for_stu,
x_im_s_est_cont_from_income => l_fnar.im_s_est_cont_from_income,
x_im_s_est_cont_from_assets => l_fnar.im_s_est_cont_from_assets,
x_im_s_opt_agi_taxable_income => l_fnar.im_s_opt_agi_taxable_income,
x_im_s_opt_untx_inc_and_ben => l_fnar.im_s_opt_untx_inc_and_ben,
x_im_s_opt_inc_adj => l_fnar.im_s_opt_inc_adj,
x_im_s_opt_total_income => l_fnar.im_s_opt_total_income,
x_im_s_opt_us_income_tax => l_fnar.im_s_opt_us_income_tax,
x_im_s_opt_state_and_oth_taxes => l_fnar.im_s_opt_state_and_oth_taxes,
x_im_s_opt_fica_tax => l_fnar.im_s_opt_fica_tax,
x_im_s_opt_med_dental => l_fnar.im_s_opt_med_dental,
x_im_s_opt_employment_allow => l_fnar.im_s_opt_employment_allow,
x_im_s_opt_annual_ed_savings => l_fnar.im_s_opt_annual_ed_savings,
x_im_s_opt_inc_prot_allow_m => l_fnar.im_s_opt_inc_prot_allow_m,
x_im_s_opt_total_inc_allow => l_fnar.im_s_opt_total_inc_allow,
x_im_s_opt_cal_avail_income => l_fnar.im_s_opt_cal_avail_income,
x_im_s_opt_avail_income => l_fnar.im_s_opt_avail_income,
x_im_s_opt_total_cont_inc => l_fnar.im_s_opt_total_cont_inc,
x_im_s_opt_cash_bank_accounts => l_fnar.im_s_opt_cash_bank_accounts,
x_im_s_opt_ira_keogh_accounts => l_fnar.im_s_opt_ira_keogh_accounts,
x_im_s_opt_home_equity => l_fnar.im_s_opt_home_equity,
x_im_s_opt_ot_rl_est_inv_eq => l_fnar.im_s_opt_ot_rl_est_inv_eq,
x_im_s_opt_adj_bus_farm_worth => l_fnar.im_s_opt_adj_bus_farm_worth,
x_im_s_opt_trusts => l_fnar.im_s_opt_trusts,
x_im_s_opt_net_worth => l_fnar.im_s_opt_net_worth,
x_im_s_opt_emerg_res_allow => l_fnar.im_s_opt_emerg_res_allow,
x_im_s_opt_cum_ed_savings => l_fnar.im_s_opt_cum_ed_savings,
x_im_s_opt_total_asset_allow => l_fnar.im_s_opt_total_asset_allow,
x_im_s_opt_disc_net_worth => l_fnar.im_s_opt_disc_net_worth,
x_im_s_opt_total_cont_asset => l_fnar.im_s_opt_total_cont_asset,
x_im_s_opt_total_cont => l_fnar.im_s_opt_total_cont,
x_im_s_opt_num_in_coll_adj => l_fnar.im_s_opt_num_in_coll_adj,
x_im_s_opt_cont_for_stu => l_fnar.im_s_opt_cont_for_stu,
x_im_s_opt_cont_from_income => l_fnar.im_s_opt_cont_from_income,
x_im_s_opt_cont_from_assets => l_fnar.im_s_opt_cont_from_assets,
x_fm_s_analysis_type => l_fnar.fm_s_analysis_type,
x_fm_s_agi_taxable_income => l_fnar.fm_s_agi_taxable_income,
x_fm_s_untx_inc_and_ben => l_fnar.fm_s_untx_inc_and_ben,
x_fm_s_inc_adj => l_fnar.fm_s_inc_adj,
x_fm_s_total_income => l_fnar.fm_s_total_income,
x_fm_s_us_income_tax => l_fnar.fm_s_us_income_tax,
x_fm_s_state_and_oth_taxes => l_fnar.fm_s_state_and_oth_taxes,
x_fm_s_fica_tax => l_fnar.fm_s_fica_tax,
x_fm_s_employment_allow => l_fnar.fm_s_employment_allow,
x_fm_s_income_prot_allow => l_fnar.fm_s_income_prot_allow,
x_fm_s_total_allow => l_fnar.fm_s_total_allow,
x_fm_s_cal_avail_income => l_fnar.fm_s_cal_avail_income,
x_fm_s_avail_income => l_fnar.fm_s_avail_income,
x_fm_s_cash_bank_accounts => l_fnar.fm_s_cash_bank_accounts,
x_fm_s_ot_rl_est_inv_equity => l_fnar.fm_s_ot_rl_est_inv_equity,
x_fm_s_adj_bus_farm_worth => l_fnar.fm_s_adj_bus_farm_worth,
x_fm_s_trusts => l_fnar.fm_s_trusts,
x_fm_s_net_worth => l_fnar.fm_s_net_worth,
x_fm_s_asset_prot_allow => l_fnar.fm_s_asset_prot_allow,
x_fm_s_disc_net_worth => l_fnar.fm_s_disc_net_worth,
x_fm_s_total_cont => l_fnar.fm_s_total_cont,
x_fm_s_num_in_coll => l_fnar.fm_s_num_in_coll,
x_fm_s_cont_for_stu => l_fnar.fm_s_cont_for_stu,
x_fm_s_cont_from_income => l_fnar.fm_s_cont_from_income,
x_fm_s_cont_from_assets => l_fnar.fm_s_cont_from_assets,
x_im_inst_resident_ind => l_fnar.im_inst_resident_ind,
x_institutional_1_budget_name => l_fnar.institutional_1_budget_name,
x_im_inst_1_budget_duration => l_fnar.im_inst_1_budget_duration,
x_im_inst_1_tuition_fees => l_fnar.im_inst_1_tuition_fees,
x_im_inst_1_books_supplies => l_fnar.im_inst_1_books_supplies,
x_im_inst_1_living_expenses => l_fnar.im_inst_1_living_expenses,
x_im_inst_1_tot_expenses => l_fnar.im_inst_1_tot_expenses,
x_im_inst_1_tot_stu_cont => l_fnar.im_inst_1_tot_stu_cont,
x_im_inst_1_tot_par_cont => l_fnar.im_inst_1_tot_par_cont,
x_im_inst_1_tot_family_cont => l_fnar.im_inst_1_tot_family_cont,
x_im_inst_1_va_benefits => l_fnar.im_inst_1_va_benefits,
x_im_inst_1_ot_cont => l_fnar.im_inst_1_ot_cont,
x_im_inst_1_est_financial_need => l_fnar.im_inst_1_est_financial_need,
x_institutional_2_budget_name => l_fnar.institutional_2_budget_name,
x_im_inst_2_budget_duration => l_fnar.im_inst_2_budget_duration,
x_im_inst_2_tuition_fees => l_fnar.im_inst_2_tuition_fees,
x_im_inst_2_books_supplies => l_fnar.im_inst_2_books_supplies,
x_im_inst_2_living_expenses => l_fnar.im_inst_2_living_expenses,
x_im_inst_2_tot_expenses => l_fnar.im_inst_2_tot_expenses,
x_im_inst_2_tot_stu_cont => l_fnar.im_inst_2_tot_stu_cont,
x_im_inst_2_tot_par_cont => l_fnar.im_inst_2_tot_par_cont,
x_im_inst_2_tot_family_cont => l_fnar.im_inst_2_tot_family_cont,
x_im_inst_2_va_benefits => l_fnar.im_inst_2_va_benefits,
x_im_inst_2_est_financial_need => l_fnar.im_inst_2_est_financial_need,
x_institutional_3_budget_name => l_fnar.institutional_3_budget_name,
x_im_inst_3_budget_duration => l_fnar.im_inst_3_budget_duration,
x_im_inst_3_tuition_fees => l_fnar.im_inst_3_tuition_fees,
x_im_inst_3_books_supplies => l_fnar.im_inst_3_books_supplies,
x_im_inst_3_living_expenses => l_fnar.im_inst_3_living_expenses,
x_im_inst_3_tot_expenses => l_fnar.im_inst_3_tot_expenses,
x_im_inst_3_tot_stu_cont => l_fnar.im_inst_3_tot_stu_cont,
x_im_inst_3_tot_par_cont => l_fnar.im_inst_3_tot_par_cont,
x_im_inst_3_tot_family_cont => l_fnar.im_inst_3_tot_family_cont,
x_im_inst_3_va_benefits => l_fnar.im_inst_3_va_benefits,
x_im_inst_3_est_financial_need => l_fnar.im_inst_3_est_financial_need,
x_fm_inst_1_federal_efc => l_fnar.fm_inst_1_federal_efc,
x_fm_inst_1_va_benefits => l_fnar.fm_inst_1_va_benefits,
x_fm_inst_1_fed_eligibility => l_fnar.fm_inst_1_fed_eligibility,
x_fm_inst_1_pell => l_fnar.fm_inst_1_pell,
x_option_par_loss_allow_ind => l_fnar.option_par_loss_allow_ind,
x_option_par_tuition_ind => l_fnar.option_par_tuition_ind,
x_option_par_home_ind => l_fnar.option_par_home_ind,
x_option_par_home_value => l_fnar.option_par_home_value,
x_option_par_home_debt => l_fnar.option_par_home_debt,
x_option_stu_ira_keogh_ind => l_fnar.option_stu_ira_keogh_ind,
x_option_stu_home_ind => l_fnar.option_stu_home_ind,
x_option_stu_home_value => l_fnar.option_stu_home_value,
x_option_stu_home_debt => l_fnar.option_stu_home_debt,
x_option_stu_sum_ay_inc_ind => l_fnar.option_stu_sum_ay_inc_ind,
x_option_par_hope_ll_credit => l_fnar.option_par_hope_ll_credit,
x_option_stu_hope_ll_credit => l_fnar.option_stu_hope_ll_credit,
x_im_parent_1_8_months_bas => l_fnar.im_parent_1_8_months_bas,
x_im_p_more_than_9_mth_ba => l_fnar.im_p_more_than_9_mth_ba,
x_im_parent_1_8_months_opt => l_fnar.im_parent_1_8_months_opt,
x_im_p_more_than_9_mth_op => l_fnar.im_p_more_than_9_mth_op,
x_fnar_message_1 => l_fnar.fnar_message_1,
x_fnar_message_2 => l_fnar.fnar_message_2,
x_fnar_message_3 => l_fnar.fnar_message_3,
x_fnar_message_4 => l_fnar.fnar_message_4,
x_fnar_message_5 => l_fnar.fnar_message_5,
x_fnar_message_6 => l_fnar.fnar_message_6,
x_fnar_message_7 => l_fnar.fnar_message_7,
x_fnar_message_8 => l_fnar.fnar_message_8,
x_fnar_message_9 => l_fnar.fnar_message_9,
x_fnar_message_10 => l_fnar.fnar_message_10,
x_fnar_message_11 => l_fnar.fnar_message_11,
x_fnar_message_12 => l_fnar.fnar_message_12,
x_fnar_message_13 => l_fnar.fnar_message_13,
x_fnar_message_20 => l_fnar.fnar_message_20,
x_fnar_message_21 => l_fnar.fnar_message_21,
x_fnar_message_22 => l_fnar.fnar_message_22,
x_fnar_message_23 => l_fnar.fnar_message_23,
x_fnar_message_24 => l_fnar.fnar_message_24,
x_fnar_message_25 => l_fnar.fnar_message_25,
x_fnar_message_26 => l_fnar.fnar_message_26,
x_fnar_message_27 => l_fnar.fnar_message_27,
x_fnar_message_30 => l_fnar.fnar_message_30,
x_fnar_message_31 => l_fnar.fnar_message_31,
x_fnar_message_32 => l_fnar.fnar_message_32,
x_fnar_message_33 => l_fnar.fnar_message_33,
x_fnar_message_34 => l_fnar.fnar_message_34,
x_fnar_message_35 => l_fnar.fnar_message_35,
x_fnar_message_36 => l_fnar.fnar_message_36,
x_fnar_message_37 => l_fnar.fnar_message_37,
x_fnar_message_38 => l_fnar.fnar_message_38,
x_fnar_message_39 => l_fnar.fnar_message_39,
x_fnar_message_45 => l_fnar.fnar_message_45,
x_fnar_message_46 => l_fnar.fnar_message_46,
x_fnar_message_47 => l_fnar.fnar_message_47,
x_fnar_message_48 => l_fnar.fnar_message_48,
x_fnar_message_50 => l_fnar.fnar_message_50,
x_fnar_message_51 => l_fnar.fnar_message_51,
x_fnar_message_52 => l_fnar.fnar_message_52,
x_fnar_message_53 => l_fnar.fnar_message_53,
x_fnar_message_56 => l_fnar.fnar_message_56,
x_fnar_message_57 => l_fnar.fnar_message_57,
x_fnar_message_58 => l_fnar.fnar_message_58,
x_fnar_message_59 => l_fnar.fnar_message_59,
x_fnar_message_60 => l_fnar.fnar_message_60,
x_fnar_message_61 => l_fnar.fnar_message_61,
x_fnar_message_62 => l_fnar.fnar_message_62,
x_fnar_message_63 => l_fnar.fnar_message_63,
x_fnar_message_64 => l_fnar.fnar_message_64,
x_fnar_message_65 => l_fnar.fnar_message_65,
x_fnar_message_71 => l_fnar.fnar_message_71,
x_fnar_message_72 => l_fnar.fnar_message_72,
x_fnar_message_73 => l_fnar.fnar_message_73,
x_fnar_message_74 => l_fnar.fnar_message_74,
x_fnar_message_75 => l_fnar.fnar_message_75,
x_fnar_message_76 => l_fnar.fnar_message_76,
x_fnar_message_77 => l_fnar.fnar_message_77,
x_fnar_message_78 => l_fnar.fnar_message_78,
x_fnar_mesg_10_stu_fam_mem => l_fnar.fnar_mesg_10_stu_fam_mem,
x_fnar_mesg_11_stu_no_in_coll => l_fnar.fnar_mesg_11_stu_no_in_coll,
x_fnar_mesg_24_stu_avail_inc => l_fnar.fnar_mesg_24_stu_avail_inc,
x_fnar_mesg_26_stu_taxes => l_fnar.fnar_mesg_26_stu_taxes,
x_fnar_mesg_33_stu_home_value => l_fnar.fnar_mesg_33_stu_home_value,
x_fnar_mesg_34_stu_home_value => l_fnar.fnar_mesg_34_stu_home_value,
x_fnar_mesg_34_stu_home_equity => l_fnar.fnar_mesg_34_stu_home_equity,
x_fnar_mesg_35_stu_home_value => l_fnar.fnar_mesg_35_stu_home_value,
x_fnar_mesg_35_stu_home_equity => l_fnar.fnar_mesg_35_stu_home_equity,
x_fnar_mesg_36_stu_home_equity => l_fnar.fnar_mesg_36_stu_home_equity,
x_fnar_mesg_48_par_fam_mem => l_fnar.fnar_mesg_48_par_fam_mem,
x_fnar_mesg_49_par_no_in_coll => l_fnar.fnar_mesg_49_par_no_in_coll,
x_fnar_mesg_56_par_agi => l_fnar.fnar_mesg_56_par_agi,
x_fnar_mesg_62_par_taxes => l_fnar.fnar_mesg_62_par_taxes,
x_fnar_mesg_73_par_home_value => l_fnar.fnar_mesg_73_par_home_value,
x_fnar_mesg_74_par_home_value => l_fnar.fnar_mesg_74_par_home_value,
x_fnar_mesg_74_par_home_equity => l_fnar.fnar_mesg_74_par_home_equity,
x_fnar_mesg_75_par_home_value => l_fnar.fnar_mesg_75_par_home_value,
x_fnar_mesg_75_par_home_equity => l_fnar.fnar_mesg_75_par_home_equity,
x_fnar_mesg_76_par_home_equity => l_fnar.fnar_mesg_76_par_home_equity,
x_assumption_message_1 => l_fnar.assumption_message_1,
x_assumption_message_2 => l_fnar.assumption_message_2,
x_assumption_message_3 => l_fnar.assumption_message_3,
x_assumption_message_4 => l_fnar.assumption_message_4,
x_assumption_message_5 => l_fnar.assumption_message_5,
x_assumption_message_6 => l_fnar.assumption_message_6,
x_record_mark => l_fnar.record_mark,
x_mode => 'R',
x_fnar_message_55 => l_fnar.fnar_message_55,
x_fnar_message_49 => l_fnar.fnar_message_49,
x_opt_par_cola_adj_ind => l_fnar.option_par_cola_adj_ind,
x_opt_par_stu_fa_assets_ind => l_fnar.option_par_stu_fa_assets_ind,
x_opt_par_ipt_assets_ind => l_fnar.option_par_ipt_assets_ind,
x_opt_stu_ipt_assets_ind => l_fnar.option_stu_ipt_assets_ind,
x_opt_par_cola_adj_value => l_fnar.option_par_cola_adj_value,
x_legacy_record_flag => l_fnar.legacy_record_flag,
x_opt_ind_stu_ipt_assets_flag => l_fnar.option_ind_stu_ipt_assets_flag,
x_cust_parent_cont_adj_num => l_fnar.cust_parent_cont_adj_num,
x_custodial_parent_num => l_fnar.custodial_parent_num,
x_cust_par_base_prcnt_inc_amt => l_fnar.cust_par_base_prcnt_inc_amt,
x_cust_par_base_cont_inc_amt => l_fnar.cust_par_base_cont_inc_amt,
x_cust_par_base_cont_ast_amt => l_fnar.cust_par_base_cont_ast_amt,
x_cust_par_base_tot_cont_amt => l_fnar.cust_par_base_tot_cont_amt,
x_cust_par_opt_prcnt_inc_amt => l_fnar.cust_par_opt_prcnt_inc_amt,
x_cust_par_opt_cont_inc_amt => l_fnar.cust_par_opt_cont_inc_amt,
x_cust_par_opt_cont_ast_amt => l_fnar.cust_par_opt_cont_ast_amt,
x_cust_par_opt_tot_cont_amt => l_fnar.cust_par_opt_cont_ast_amt,
x_parents_email_txt => l_fnar.parents_email_txt,
x_parent_1_birth_date => l_fnar.parent_1_birth_date,
x_parent_2_birth_date => l_fnar.parent_2_birth_date
);
END; -- End of PROFILE Update block
SELECT base_id
FROM igf_ap_fa_base_rec_all
WHERE ci_sequence_number = cp_seq_number
AND ci_cal_type = cp_cal_type
AND person_id = cp_person_id;
SELECT base_id
FROM igf_ap_fa_base_rec_all
WHERE ci_sequence_number = cp_seq_number
AND ci_cal_type = cp_cal_type;
OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number, p_persid_grp;
OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number;