27: g_person_id per_all_people_f.person_id%TYPE;
28: --
29: g_chg_evt_cd varchar2(30);
30: g_chg_evt_source varchar2(30);
31: g_chg_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
32: g_chg_actl_dt ben_ext_chg_evt_log.chg_actl_dt%TYPE;
33: g_chg_last_update_login ben_ext_chg_evt_log.last_update_login%TYPE;
34: g_chg_pl_id number(15);
35: g_chg_enrt_rslt_id number(15);
28: --
29: g_chg_evt_cd varchar2(30);
30: g_chg_evt_source varchar2(30);
31: g_chg_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
32: g_chg_actl_dt ben_ext_chg_evt_log.chg_actl_dt%TYPE;
33: g_chg_last_update_login ben_ext_chg_evt_log.last_update_login%TYPE;
34: g_chg_pl_id number(15);
35: g_chg_enrt_rslt_id number(15);
36: g_chg_input_value_id number(15);
29: g_chg_evt_cd varchar2(30);
30: g_chg_evt_source varchar2(30);
31: g_chg_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
32: g_chg_actl_dt ben_ext_chg_evt_log.chg_actl_dt%TYPE;
33: g_chg_last_update_login ben_ext_chg_evt_log.last_update_login%TYPE;
34: g_chg_pl_id number(15);
35: g_chg_enrt_rslt_id number(15);
36: g_chg_input_value_id number(15);
37: g_ext_chg_evt_log_id number(15);
34: g_chg_pl_id number(15);
35: g_chg_enrt_rslt_id number(15);
36: g_chg_input_value_id number(15);
37: g_ext_chg_evt_log_id number(15);
38: g_chg_prmtr_01 ben_ext_chg_evt_log.prmtr_01%TYPE;
39: g_chg_prmtr_02 ben_ext_chg_evt_log.prmtr_02%TYPE;
40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
35: g_chg_enrt_rslt_id number(15);
36: g_chg_input_value_id number(15);
37: g_ext_chg_evt_log_id number(15);
38: g_chg_prmtr_01 ben_ext_chg_evt_log.prmtr_01%TYPE;
39: g_chg_prmtr_02 ben_ext_chg_evt_log.prmtr_02%TYPE;
40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
36: g_chg_input_value_id number(15);
37: g_ext_chg_evt_log_id number(15);
38: g_chg_prmtr_01 ben_ext_chg_evt_log.prmtr_01%TYPE;
39: g_chg_prmtr_02 ben_ext_chg_evt_log.prmtr_02%TYPE;
40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
37: g_ext_chg_evt_log_id number(15);
38: g_chg_prmtr_01 ben_ext_chg_evt_log.prmtr_01%TYPE;
39: g_chg_prmtr_02 ben_ext_chg_evt_log.prmtr_02%TYPE;
40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
38: g_chg_prmtr_01 ben_ext_chg_evt_log.prmtr_01%TYPE;
39: g_chg_prmtr_02 ben_ext_chg_evt_log.prmtr_02%TYPE;
40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
39: g_chg_prmtr_02 ben_ext_chg_evt_log.prmtr_02%TYPE;
40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%TYPE;
46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%TYPE;
54: g_chg_new_val5 ben_ext_chg_evt_log.new_val5%TYPE;
47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%TYPE;
54: g_chg_new_val5 ben_ext_chg_evt_log.new_val5%TYPE;
55: g_chg_new_val6 ben_ext_chg_evt_log.new_val6%TYPE;
48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%TYPE;
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%TYPE;
54: g_chg_new_val5 ben_ext_chg_evt_log.new_val5%TYPE;
55: g_chg_new_val6 ben_ext_chg_evt_log.new_val6%TYPE;
56: g_chg_pay_table varchar2(50);
49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%TYPE;
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%TYPE;
54: g_chg_new_val5 ben_ext_chg_evt_log.new_val5%TYPE;
55: g_chg_new_val6 ben_ext_chg_evt_log.new_val6%TYPE;
56: g_chg_pay_table varchar2(50);
57: g_chg_pay_column varchar2(50);
50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%TYPE;
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%TYPE;
54: g_chg_new_val5 ben_ext_chg_evt_log.new_val5%TYPE;
55: g_chg_new_val6 ben_ext_chg_evt_log.new_val6%TYPE;
56: g_chg_pay_table varchar2(50);
57: g_chg_pay_column varchar2(50);
58: g_chg_pay_mode varchar2(50);
51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%TYPE;
52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%TYPE;
53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%TYPE;
54: g_chg_new_val5 ben_ext_chg_evt_log.new_val5%TYPE;
55: g_chg_new_val6 ben_ext_chg_evt_log.new_val6%TYPE;
56: g_chg_pay_table varchar2(50);
57: g_chg_pay_column varchar2(50);
58: g_chg_pay_mode varchar2(50);
59: g_chg_update_type pay_datetracked_events.update_type%type ;