DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_EXT_CHG_EVT_LOG

Line 31: g_chg_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;

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);

Line 32: g_chg_actl_dt ben_ext_chg_evt_log.chg_actl_dt%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);
36: g_chg_input_value_id number(15);

Line 33: g_chg_last_update_login ben_ext_chg_evt_log.last_update_login%TYPE;

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);

Line 38: g_chg_prmtr_01 ben_ext_chg_evt_log.prmtr_01%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);
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;

Line 39: g_chg_prmtr_02 ben_ext_chg_evt_log.prmtr_02%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;

Line 40: g_chg_prmtr_03 ben_ext_chg_evt_log.prmtr_03%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;

Line 41: g_chg_prmtr_04 ben_ext_chg_evt_log.prmtr_04%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;

Line 42: g_chg_prmtr_05 ben_ext_chg_evt_log.prmtr_05%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;

Line 43: g_chg_prmtr_06 ben_ext_chg_evt_log.prmtr_06%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;

Line 44: g_chg_old_val1 ben_ext_chg_evt_log.old_val1%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;

Line 45: g_chg_old_val2 ben_ext_chg_evt_log.old_val2%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;

Line 46: g_chg_old_val3 ben_ext_chg_evt_log.old_val3%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;

Line 47: g_chg_old_val4 ben_ext_chg_evt_log.old_val4%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;

Line 48: g_chg_old_val5 ben_ext_chg_evt_log.old_val5%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;

Line 49: g_chg_old_val6 ben_ext_chg_evt_log.old_val6%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;

Line 50: g_chg_new_val1 ben_ext_chg_evt_log.new_val1%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;

Line 51: g_chg_new_val2 ben_ext_chg_evt_log.new_val2%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;

Line 52: g_chg_new_val3 ben_ext_chg_evt_log.new_val3%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);

Line 53: g_chg_new_val4 ben_ext_chg_evt_log.new_val4%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);
57: g_chg_pay_column varchar2(50);

Line 54: g_chg_new_val5 ben_ext_chg_evt_log.new_val5%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);
58: g_chg_pay_mode varchar2(50);

Line 55: g_chg_new_val6 ben_ext_chg_evt_log.new_val6%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);
59: g_chg_update_type pay_datetracked_events.update_type%type ;