19: Begin
20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: ben_ext_person.g_CWB_Budget_PL_ID := null ;
24: ben_ext_person.g_CWB_Budget_Access := null ;
25: ben_ext_person.g_CWB_Budget_Approval := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: ben_ext_person.g_CWB_Budget_PL_ID := null ;
24: ben_ext_person.g_CWB_Budget_Access := null ;
25: ben_ext_person.g_CWB_Budget_Approval := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: ben_ext_person.g_CWB_Budget_PL_ID := null ;
24: ben_ext_person.g_CWB_Budget_Access := null ;
25: ben_ext_person.g_CWB_Budget_Approval := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
22: --
23: ben_ext_person.g_CWB_Budget_PL_ID := null ;
24: ben_ext_person.g_CWB_Budget_Access := null ;
25: ben_ext_person.g_CWB_Budget_Approval := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
23: ben_ext_person.g_CWB_Budget_PL_ID := null ;
24: ben_ext_person.g_CWB_Budget_Access := null ;
25: ben_ext_person.g_CWB_Budget_Approval := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
24: ben_ext_person.g_CWB_Budget_Access := null ;
25: ben_ext_person.g_CWB_Budget_Approval := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
25: ben_ext_person.g_CWB_Budget_Approval := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
26: ben_ext_person.g_CWB_Budget_Approval_Date := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
27: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
28: ben_ext_person.g_CWB_Budget_Due_Date := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
29: ben_ext_person.g_CWB_Budget_Group_Option_Name := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
30: ben_ext_person.g_CWB_Budget_Group_Plan_Name := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
31: ben_ext_person.g_CWB_Budget_Last_Updt_By := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
32: ben_ext_person.g_CWB_Budget_Last_Updt_dt := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
33: ben_ext_person.g_CWB_Budget_Population := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
34: ben_ext_person.g_CWB_Budget_Resv_Max_Value := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
35: ben_ext_person.g_CWB_Budget_Resv_Min_Value := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
36: ben_ext_person.g_CWB_Budget_Resv_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
37: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
38: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
39: ben_ext_person.g_CWB_Budget_Submit_date := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
40: ben_ext_person.g_CWB_Budget_Submit_Name := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
41: ben_ext_person.g_CWB_Budget_WS_Budget_Value := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
42: ben_ext_person.g_CWB_Dist_Budget_Default_Val := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
43: ben_ext_person.g_CWB_Dist_Budget_Issue_date := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
44: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
52: ben_ext_person.g_CWB_WS_Budget_Min_Value := null ;
45: ben_ext_person.g_CWB_Dist_Budget_Max_Value := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
52: ben_ext_person.g_CWB_WS_Budget_Min_Value := null ;
53: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := null ;
46: ben_ext_person.g_CWB_Dist_Budget_Min_Value := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
52: ben_ext_person.g_CWB_WS_Budget_Min_Value := null ;
53: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := null ;
54: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := null ;
47: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := null ;
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
52: ben_ext_person.g_CWB_WS_Budget_Min_Value := null ;
53: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := null ;
54: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := null ;
55:
48: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := null ;
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
52: ben_ext_person.g_CWB_WS_Budget_Min_Value := null ;
53: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := null ;
54: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := null ;
55:
56:
49: ben_ext_person.g_CWB_WS_Budget_Issue_Date := null ;
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
52: ben_ext_person.g_CWB_WS_Budget_Min_Value := null ;
53: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := null ;
54: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := null ;
55:
56:
57: --
50: ben_ext_person.g_CWB_WS_Budget_Issue_Value := null ;
51: ben_ext_person.g_CWB_WS_Budget_Max_Value := null ;
52: ben_ext_person.g_CWB_WS_Budget_Min_Value := null ;
53: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := null ;
54: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := null ;
55:
56:
57: --
58: hr_utility.set_location('Exiting'||l_proc, 15);
67: --
68: Begin
69: --
70: hr_utility.set_location('Entering'||l_proc, 5);
71: ben_ext_person.g_CWB_Awrd_Elig_Flag := null ;
72: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := null ;
73: ben_ext_person.g_CWB_Awrd_Group_Option_Name := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
68: Begin
69: --
70: hr_utility.set_location('Entering'||l_proc, 5);
71: ben_ext_person.g_CWB_Awrd_Elig_Flag := null ;
72: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := null ;
73: ben_ext_person.g_CWB_Awrd_Group_Option_Name := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
69: --
70: hr_utility.set_location('Entering'||l_proc, 5);
71: ben_ext_person.g_CWB_Awrd_Elig_Flag := null ;
72: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := null ;
73: ben_ext_person.g_CWB_Awrd_Group_Option_Name := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
70: hr_utility.set_location('Entering'||l_proc, 5);
71: ben_ext_person.g_CWB_Awrd_Elig_Flag := null ;
72: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := null ;
73: ben_ext_person.g_CWB_Awrd_Group_Option_Name := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
71: ben_ext_person.g_CWB_Awrd_Elig_Flag := null ;
72: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := null ;
73: ben_ext_person.g_CWB_Awrd_Group_Option_Name := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
72: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := null ;
73: ben_ext_person.g_CWB_Awrd_Group_Option_Name := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
73: ben_ext_person.g_CWB_Awrd_Group_Option_Name := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
74: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
75: ben_ext_person.g_CWB_Awrd_Plan_Name := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
76: ben_ext_person.g_CWB_Awrd_Option_Name := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
84: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := null ;
77: ben_ext_person.g_CWB_Awrd_Misc_Value1 := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
84: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := null ;
85: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := null ;
78: ben_ext_person.g_CWB_Awrd_Misc_Value2 := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
84: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := null ;
85: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := null ;
86: ben_ext_person.g_CWB_Awrd_WS_Value := null ;
79: ben_ext_person.g_CWB_Awrd_Misc_Value3 := null ;
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
84: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := null ;
85: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := null ;
86: ben_ext_person.g_CWB_Awrd_WS_Value := null ;
87: hr_utility.set_location('Exiting'||l_proc, 15);
80: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := null ;
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
84: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := null ;
85: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := null ;
86: ben_ext_person.g_CWB_Awrd_WS_Value := null ;
87: hr_utility.set_location('Exiting'||l_proc, 15);
88: --
81: ben_ext_person.g_CWB_Awrd_Recorded_Value := null ;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
84: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := null ;
85: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := null ;
86: ben_ext_person.g_CWB_Awrd_WS_Value := null ;
87: hr_utility.set_location('Exiting'||l_proc, 15);
88: --
89: End initialize_rate_globals;
82: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := null ;
83: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := null ;
84: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := null ;
85: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := null ;
86: ben_ext_person.g_CWB_Awrd_WS_Value := null ;
87: hr_utility.set_location('Exiting'||l_proc, 15);
88: --
89: End initialize_rate_globals;
90:
170: initialize_group_globals ;
171: --
172: for l_cwg in c_cwg
173: Loop
174: ben_ext_person.g_CWB_Budget_PL_ID := l_cwg.GROUP_PL_ID ;
175: ben_ext_person.g_CWB_Budget_Access := l_cwg.ACCESS_CD ;
176: ben_ext_person.g_CWB_Budget_Approval := l_cwg.APPROVAL_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
171: --
172: for l_cwg in c_cwg
173: Loop
174: ben_ext_person.g_CWB_Budget_PL_ID := l_cwg.GROUP_PL_ID ;
175: ben_ext_person.g_CWB_Budget_Access := l_cwg.ACCESS_CD ;
176: ben_ext_person.g_CWB_Budget_Approval := l_cwg.APPROVAL_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
172: for l_cwg in c_cwg
173: Loop
174: ben_ext_person.g_CWB_Budget_PL_ID := l_cwg.GROUP_PL_ID ;
175: ben_ext_person.g_CWB_Budget_Access := l_cwg.ACCESS_CD ;
176: ben_ext_person.g_CWB_Budget_Approval := l_cwg.APPROVAL_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
173: Loop
174: ben_ext_person.g_CWB_Budget_PL_ID := l_cwg.GROUP_PL_ID ;
175: ben_ext_person.g_CWB_Budget_Access := l_cwg.ACCESS_CD ;
176: ben_ext_person.g_CWB_Budget_Approval := l_cwg.APPROVAL_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
174: ben_ext_person.g_CWB_Budget_PL_ID := l_cwg.GROUP_PL_ID ;
175: ben_ext_person.g_CWB_Budget_Access := l_cwg.ACCESS_CD ;
176: ben_ext_person.g_CWB_Budget_Approval := l_cwg.APPROVAL_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
175: ben_ext_person.g_CWB_Budget_Access := l_cwg.ACCESS_CD ;
176: ben_ext_person.g_CWB_Budget_Approval := l_cwg.APPROVAL_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
176: ben_ext_person.g_CWB_Budget_Approval := l_cwg.APPROVAL_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
177: ben_ext_person.g_CWB_Budget_Approval_Date := l_cwg.APPROVAL_DATE ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
178: ben_ext_person.g_CWB_Budget_Dist_Budget_Value := l_cwg.DIST_BDGT_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
179: ben_ext_person.g_CWB_Budget_Due_Date := l_cwg.DUE_DT ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
180: --ben_ext_person.g_CWB_Budget_Group_Option_Name := l_cwg.opt_name ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
181: ben_ext_person.g_CWB_Budget_Group_Plan_Name := l_cwg.pl_name ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
182: ben_ext_person.g_CWB_Budget_Last_Updt_By := l_cwg.LAST_UPDATED_BY ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
183: ben_ext_person.g_CWB_Budget_Last_Updt_dt := l_cwg.LAST_UPDATE_DATE ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
184: ben_ext_person.g_CWB_Budget_Population := l_cwg.BDGT_POP_CD ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
185: ben_ext_person.g_CWB_Budget_Resv_Max_Value := l_cwg.RSRV_MX_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
186: ben_ext_person.g_CWB_Budget_Resv_Min_Value := l_cwg.RSRV_MN_VAL ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
187: ben_ext_person.g_CWB_Budget_Resv_Value := l_cwg.RSRV_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
188: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_By := l_cwg.RSRV_VAL_LAST_UPD_BY ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
189: ben_ext_person.g_CWB_Budget_Resv_Val_Updt_dt := l_cwg.RSRV_VAL_LAST_UPD_DATE ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
190: ben_ext_person.g_CWB_Budget_Submit_date := l_cwg.SUBMIT_DATE ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
191: ben_ext_person.g_CWB_Budget_Submit_Name := l_cwg.SUBMIT_CD ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
192: ben_ext_person.g_CWB_Budget_WS_Budget_Value := l_cwg.DFLT_DIST_BDGT_VAL ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
193: ben_ext_person.g_CWB_Dist_Budget_Default_Val := l_cwg.DFLT_DIST_BDGT_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
194: ben_ext_person.g_CWB_Dist_Budget_Issue_date := l_cwg.DIST_BDGT_ISS_DATE ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
195: ben_ext_person.g_CWB_Dist_Budget_Issue_Value := l_cwg.DIST_BDGT_ISS_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
203: ben_ext_person.g_CWB_WS_Budget_Min_Value := l_cwg.WS_BDGT_MN_VAL ;
196: ben_ext_person.g_CWB_Dist_Budget_Max_Value := l_cwg.DIST_BDGT_MX_VAL ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
203: ben_ext_person.g_CWB_WS_Budget_Min_Value := l_cwg.WS_BDGT_MN_VAL ;
204: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := l_cwg.WS_BDGT_VAL_LAST_UPD_BY ;
197: ben_ext_person.g_CWB_Dist_Budget_Min_Value := l_cwg.DIST_BDGT_MN_VAL ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
203: ben_ext_person.g_CWB_WS_Budget_Min_Value := l_cwg.WS_BDGT_MN_VAL ;
204: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := l_cwg.WS_BDGT_VAL_LAST_UPD_BY ;
205: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := l_cwg.WS_BDGT_VAL_LAST_UPD_DATE ;
198: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_By := l_cwg.DIST_BDGT_VAL_LAST_UPD_BY ;
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
203: ben_ext_person.g_CWB_WS_Budget_Min_Value := l_cwg.WS_BDGT_MN_VAL ;
204: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := l_cwg.WS_BDGT_VAL_LAST_UPD_BY ;
205: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := l_cwg.WS_BDGT_VAL_LAST_UPD_DATE ;
206:
199: ben_ext_person.g_CWB_Dist_Budget_Val_Updt_dt := l_cwg.DIST_BDGT_VAL_LAST_UPD_DATE ;
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
203: ben_ext_person.g_CWB_WS_Budget_Min_Value := l_cwg.WS_BDGT_MN_VAL ;
204: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := l_cwg.WS_BDGT_VAL_LAST_UPD_BY ;
205: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := l_cwg.WS_BDGT_VAL_LAST_UPD_DATE ;
206:
207: --- get the option namme
200: ben_ext_person.g_CWB_WS_Budget_Issue_Date := l_cwg.WS_BDGT_ISS_DATE ;
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
203: ben_ext_person.g_CWB_WS_Budget_Min_Value := l_cwg.WS_BDGT_MN_VAL ;
204: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := l_cwg.WS_BDGT_VAL_LAST_UPD_BY ;
205: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := l_cwg.WS_BDGT_VAL_LAST_UPD_DATE ;
206:
207: --- get the option namme
208: if l_cwg.group_oipl_id is not null and l_cwg.group_oipl_id <> -1 then
201: ben_ext_person.g_CWB_WS_Budget_Issue_Value := l_cwg.WS_BDGT_ISS_VAL ;
202: ben_ext_person.g_CWB_WS_Budget_Max_Value := l_cwg.WS_BDGT_MX_VAL ;
203: ben_ext_person.g_CWB_WS_Budget_Min_Value := l_cwg.WS_BDGT_MN_VAL ;
204: ben_ext_person.g_CWB_WS_Budget_Val_Updt_By := l_cwg.WS_BDGT_VAL_LAST_UPD_BY ;
205: ben_ext_person.g_CWB_WS_Budget_Val_Updt_dt := l_cwg.WS_BDGT_VAL_LAST_UPD_DATE ;
206:
207: --- get the option namme
208: if l_cwg.group_oipl_id is not null and l_cwg.group_oipl_id <> -1 then
209:
209:
210: open c_name (l_cwg.group_pl_id ,
211: l_cwg.group_oipl_id ,
212: l_cwg.lf_evt_ocrd_dt) ;
213: fetch c_name into ben_ext_person.g_CWB_Budget_Group_Option_Name ;
214: close c_name ;
215:
216: end if ;
217:
299: --
300: for l_cwr in c_cwr
301: Loop
302:
303: ben_ext_person.g_CWB_Awrd_Elig_Flag := l_Cwr.ELIG_FLAG ;
304: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := l_Cwr.ELIG_SAL_VAL ;
305: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := l_cwr.group_pl_name ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
300: for l_cwr in c_cwr
301: Loop
302:
303: ben_ext_person.g_CWB_Awrd_Elig_Flag := l_Cwr.ELIG_FLAG ;
304: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := l_Cwr.ELIG_SAL_VAL ;
305: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := l_cwr.group_pl_name ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
301: Loop
302:
303: ben_ext_person.g_CWB_Awrd_Elig_Flag := l_Cwr.ELIG_FLAG ;
304: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := l_Cwr.ELIG_SAL_VAL ;
305: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := l_cwr.group_pl_name ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
302:
303: ben_ext_person.g_CWB_Awrd_Elig_Flag := l_Cwr.ELIG_FLAG ;
304: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := l_Cwr.ELIG_SAL_VAL ;
305: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := l_cwr.group_pl_name ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
303: ben_ext_person.g_CWB_Awrd_Elig_Flag := l_Cwr.ELIG_FLAG ;
304: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := l_Cwr.ELIG_SAL_VAL ;
305: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := l_cwr.group_pl_name ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
304: ben_ext_person.g_CWB_Awrd_Elig_Salary_Value := l_Cwr.ELIG_SAL_VAL ;
305: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := l_cwr.group_pl_name ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
305: ben_ext_person.g_CWB_Awrd_Group_Plan_Name := l_cwr.group_pl_name ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
306: ben_ext_person.g_CWB_Awrd_Plan_Name := l_cwr.pl_name ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
314: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := l_Cwr.WS_MN_VAL ;
307: ben_ext_person.g_CWB_Awrd_Misc_Value1 := l_Cwr.MISC1_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
314: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := l_Cwr.WS_MN_VAL ;
315: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := l_Cwr.WS_MX_VAL ;
308: ben_ext_person.g_CWB_Awrd_Misc_Value2 := l_Cwr.MISC2_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
314: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := l_Cwr.WS_MN_VAL ;
315: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := l_Cwr.WS_MX_VAL ;
316: ben_ext_person.g_CWB_Awrd_WS_Value := l_Cwr.WS_VAL ;
309: ben_ext_person.g_CWB_Awrd_Misc_Value3 := l_Cwr.MISC3_VAL ;
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
314: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := l_Cwr.WS_MN_VAL ;
315: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := l_Cwr.WS_MX_VAL ;
316: ben_ext_person.g_CWB_Awrd_WS_Value := l_Cwr.WS_VAL ;
317:
310: ben_ext_person.g_CWB_Awrd_Other_Comp_Value := l_Cwr.OTH_COMP_VAL ;
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
314: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := l_Cwr.WS_MN_VAL ;
315: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := l_Cwr.WS_MX_VAL ;
316: ben_ext_person.g_CWB_Awrd_WS_Value := l_Cwr.WS_VAL ;
317:
318: if nvl(l_cwr.group_oipl_id,-1) <> -1 then
311: ben_ext_person.g_CWB_Awrd_Recorded_Value := l_Cwr.REC_VAL ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
314: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := l_Cwr.WS_MN_VAL ;
315: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := l_Cwr.WS_MX_VAL ;
316: ben_ext_person.g_CWB_Awrd_WS_Value := l_Cwr.WS_VAL ;
317:
318: if nvl(l_cwr.group_oipl_id,-1) <> -1 then
319: open c_oipl(l_cwr.group_oipl_id,l_cwr.group_pl_id , l_cwr.lf_evt_ocrd_dt) ;
312: ben_ext_person.g_CWB_Awrd_Stated_Salary_Value := l_Cwr.STAT_SAL_VAL ;
313: ben_ext_person.g_CWB_Awrd_Total_Comp_Value := l_Cwr.TOT_COMP_VAL ;
314: ben_ext_person.g_CWB_Awrd_WS_Maximum_Value := l_Cwr.WS_MN_VAL ;
315: ben_ext_person.g_CWB_Awrd_WS_Minimum_Value := l_Cwr.WS_MX_VAL ;
316: ben_ext_person.g_CWB_Awrd_WS_Value := l_Cwr.WS_VAL ;
317:
318: if nvl(l_cwr.group_oipl_id,-1) <> -1 then
319: open c_oipl(l_cwr.group_oipl_id,l_cwr.group_pl_id , l_cwr.lf_evt_ocrd_dt) ;
320: fetch c_oipl into ben_ext_person.g_CWB_Awrd_Group_Option_Name ;
316: ben_ext_person.g_CWB_Awrd_WS_Value := l_Cwr.WS_VAL ;
317:
318: if nvl(l_cwr.group_oipl_id,-1) <> -1 then
319: open c_oipl(l_cwr.group_oipl_id,l_cwr.group_pl_id , l_cwr.lf_evt_ocrd_dt) ;
320: fetch c_oipl into ben_ext_person.g_CWB_Awrd_Group_Option_Name ;
321: close c_oipl ;
322: end if ;
323:
324: if nvl(l_cwr.oipl_id,-1) <> -1 then
322: end if ;
323:
324: if nvl(l_cwr.oipl_id,-1) <> -1 then
325: open c_oipl(l_cwr.oipl_id,l_cwr.pl_id , l_cwr.lf_evt_ocrd_dt) ;
326: fetch c_oipl into ben_ext_person.g_CWB_Awrd_Option_Name ;
327: close c_oipl ;
328: end if ;
329:
330: