13: p_leagal_employer_id VARCHAR2
14: ) IS
15: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
16: action_information5
17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
19: daily_hours,
20: fnd_number.canonical_to_number (action_information8) days_per_year,
21: fnd_number.canonical_to_number (action_information9)
14: ) IS
15: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
16: action_information5
17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
19: daily_hours,
20: fnd_number.canonical_to_number (action_information8) days_per_year,
21: fnd_number.canonical_to_number (action_information9)
22: hours_per_year,
16: action_information5
17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
19: daily_hours,
20: fnd_number.canonical_to_number (action_information8) days_per_year,
21: fnd_number.canonical_to_number (action_information9)
22: hours_per_year,
23: fnd_date.canonical_to_date (action_information10) start_date,
24: fnd_date.canonical_to_date (action_information11)
17: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
18: fnd_number.canonical_to_number (action_information7)
19: daily_hours,
20: fnd_number.canonical_to_number (action_information8) days_per_year,
21: fnd_number.canonical_to_number (action_information9)
22: hours_per_year,
23: fnd_date.canonical_to_date (action_information10) start_date,
24: fnd_date.canonical_to_date (action_information11)
25: end_date
37: p_leagal_employer_id VARCHAR2
38: ) IS
39: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
40: action_information5
41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
43: daily_hours,
44: fnd_number.canonical_to_number (action_information8) days_per_year,
45: fnd_number.canonical_to_number (action_information9)
38: ) IS
39: SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
40: action_information5
41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
43: daily_hours,
44: fnd_number.canonical_to_number (action_information8) days_per_year,
45: fnd_number.canonical_to_number (action_information9)
46: hours_per_year,
40: action_information5
41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
43: daily_hours,
44: fnd_number.canonical_to_number (action_information8) days_per_year,
45: fnd_number.canonical_to_number (action_information9)
46: hours_per_year,
47: fnd_date.canonical_to_date (action_information10) start_date,
48: fnd_date.canonical_to_date (action_information11)
41: org_number, fnd_number.canonical_to_number (action_information6) week_hours,
42: fnd_number.canonical_to_number (action_information7)
43: daily_hours,
44: fnd_number.canonical_to_number (action_information8) days_per_year,
45: fnd_number.canonical_to_number (action_information9)
46: hours_per_year,
47: fnd_date.canonical_to_date (action_information10) start_date,
48: fnd_date.canonical_to_date (action_information11)
49: end_date
61: csr_v_pa_id pay_action_information.action_context_id%TYPE,
62: p_curr_prev_data VARCHAR2,
63: p_leagal_employer_id VARCHAR2
64: ) IS
65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
62: p_curr_prev_data VARCHAR2,
63: p_leagal_employer_id VARCHAR2
64: ) IS
65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
64: ) IS
65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
65: SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
66: fnd_number.canonical_to_number (action_information7)
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
67: men_middle_age_count,
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
68: fnd_number.canonical_to_number (action_information8) men_upper_age_count,
69: fnd_number.canonical_to_number (action_information9)
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
70: women_lower_age_count,
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
71: fnd_number.canonical_to_number (action_information10) women_middle_age_count,
72: fnd_number.canonical_to_number (action_information11)
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
73: women_upper_age_count,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
74: fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
75: fnd_number.canonical_to_number (action_information13)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
76: men_middle_age_work_hour,
77: fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
78: fnd_number.canonical_to_number (action_information15)
79: women_lower_age_work_hour,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
80: fnd_number.canonical_to_number (action_information16)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
81: women_middle_age_work_hour,
82: fnd_number.canonical_to_number (action_information17)
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
83: women_upper_age_work_hour,
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
84: fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
85: fnd_number.canonical_to_number (action_information19)
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
86: men_m_age_sick_leaves,
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
87: fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
88: fnd_number.canonical_to_number (action_information21)
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
89: women_l_age_sick_leaves,
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
90: fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
91: fnd_number.canonical_to_number (action_information23)
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
92: women_u_age_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,
93: fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
94: fnd_number.canonical_to_number (action_information25)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,
101: fnd_number.canonical_to_number (action_information29)
95: men_m_age_l_sick_leaves,
96: fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,
101: fnd_number.canonical_to_number (action_information29)
102: women_u_age_l_sick_leaves
103: FROM pay_action_information
97: fnd_number.canonical_to_number (action_information27)
98: women_l_age_l_sick_leaves,
99: fnd_number.canonical_to_number (action_information28)
100: women_m_age_l_sick_leaves,
101: fnd_number.canonical_to_number (action_information29)
102: women_u_age_l_sick_leaves
103: FROM pay_action_information
104: WHERE action_context_type = 'PA'
105: AND action_context_id = csr_v_pa_id
116: csr_v_pa_id pay_action_information.action_context_id%TYPE,
117: p_curr_prev_stat VARCHAR2,
118: p_leagal_employer_id VARCHAR2
119: ) IS
120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
117: p_curr_prev_stat VARCHAR2,
118: p_leagal_employer_id VARCHAR2
119: ) IS
120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
119: ) IS
120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
120: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
121: fnd_number.canonical_to_number (action_information7)
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,
122: long_leave_part,
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,
129: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
130: FROM pay_action_information
123: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
124: fnd_number.canonical_to_number (action_information9)
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,
129: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
130: FROM pay_action_information
131: WHERE action_context_type = 'PA'
125: women_leave_to_work_hour,
126: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
127: fnd_number.canonical_to_number (action_information11)
128: leave_to_work_hour_middle,
129: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
130: FROM pay_action_information
131: WHERE action_context_type = 'PA'
132: AND action_context_id = csr_v_pa_id
133: AND action_information_category = 'EMEA REPORT INFORMATION'
138: csr_v_pa_id pay_action_information.action_context_id%TYPE,
139: p_curr_prev_stat VARCHAR2,
140: p_leagal_employer_id VARCHAR2
141: ) IS
142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
139: p_curr_prev_stat VARCHAR2,
140: p_leagal_employer_id VARCHAR2
141: ) IS
142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
141: ) IS
142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
142: SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
143: fnd_number.canonical_to_number (action_information7)
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,
144: long_leave_part,
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,
151: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
152: FROM pay_action_information
145: fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
146: fnd_number.canonical_to_number (action_information9)
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,
151: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
152: FROM pay_action_information
153: WHERE action_context_type = 'PA'
147: women_leave_to_work_hour,
148: fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
149: fnd_number.canonical_to_number (action_information11)
150: leave_to_work_hour_middle,
151: fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
152: FROM pay_action_information
153: WHERE action_context_type = 'PA'
154: AND action_context_id = csr_v_pa_id
155: AND action_information_category = 'EMEA REPORT INFORMATION'