59: --Change History:
60: --Who When What
61: -------------------------------------------------------------------
62:
63: l_param_pass_log igf_lookups_view.meaning%TYPE ;
64: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
65: l_pers_number_log igf_lookups_view.meaning%TYPE ;
66: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
67: l_test_run_log igf_lookups_view.meaning%TYPE ;
60: --Who When What
61: -------------------------------------------------------------------
62:
63: l_param_pass_log igf_lookups_view.meaning%TYPE ;
64: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
65: l_pers_number_log igf_lookups_view.meaning%TYPE ;
66: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
67: l_test_run_log igf_lookups_view.meaning%TYPE ;
68: l_cancel_inv_awd_log igf_lookups_view.meaning%TYPE ;
61: -------------------------------------------------------------------
62:
63: l_param_pass_log igf_lookups_view.meaning%TYPE ;
64: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
65: l_pers_number_log igf_lookups_view.meaning%TYPE ;
66: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
67: l_test_run_log igf_lookups_view.meaning%TYPE ;
68: l_cancel_inv_awd_log igf_lookups_view.meaning%TYPE ;
69:
62:
63: l_param_pass_log igf_lookups_view.meaning%TYPE ;
64: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
65: l_pers_number_log igf_lookups_view.meaning%TYPE ;
66: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
67: l_test_run_log igf_lookups_view.meaning%TYPE ;
68: l_cancel_inv_awd_log igf_lookups_view.meaning%TYPE ;
69:
70: -- Get person number
63: l_param_pass_log igf_lookups_view.meaning%TYPE ;
64: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
65: l_pers_number_log igf_lookups_view.meaning%TYPE ;
66: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
67: l_test_run_log igf_lookups_view.meaning%TYPE ;
68: l_cancel_inv_awd_log igf_lookups_view.meaning%TYPE ;
69:
70: -- Get person number
71: CURSOR c_person_number(
64: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
65: l_pers_number_log igf_lookups_view.meaning%TYPE ;
66: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
67: l_test_run_log igf_lookups_view.meaning%TYPE ;
68: l_cancel_inv_awd_log igf_lookups_view.meaning%TYPE ;
69:
70: -- Get person number
71: CURSOR c_person_number(
72: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE