157: l_tax_year varchar2(50);
158: l_tax_year_start_date date;
159: --
160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
158: l_tax_year_start_date date;
159: --
160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
159: --
160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
160: BEGIN
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
161: --hr_utility.trace_on(null,'ZAEXC');
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:
162: hr_utility.set_location('p_owner_payroll_action_id: '||to_char(p_owner_payroll_action_id),10);
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:
170: select rule_mode
163: hr_utility.set_location('p_user_payroll_action_id: '||to_char(p_user_payroll_action_id),10);
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:
170: select rule_mode
171: into l_tax_start_day
164: hr_utility.set_location('p_owner_assignment_action_id: '||to_char(p_owner_assignment_action_id),10);
165: hr_utility.set_location('p_user_assignment_action_id: '||to_char(p_user_assignment_action_id),10);
166: hr_utility.set_location('p_owner_effective_date: '||to_char(p_owner_effective_date),10);
167: hr_utility.set_location('p_user_effective_date: '||to_char(p_user_effective_date),10);
168: hr_utility.set_location('p_dimension_name: '||to_char(p_dimension_name),10);
169:
170: select rule_mode
171: into l_tax_start_day
172: from pay_legislation_rules
172: from pay_legislation_rules
173: where legislation_code = 'ZA'
174: and rule_type = 'L';
175:
176: hr_utility.set_location('l_tax_start_day: '||to_char(l_tax_start_day),10);
177: --
178: select to_char(p_owner_effective_date,'YYYY')
179: into l_tax_year
180: from dual;
177: --
178: select to_char(p_owner_effective_date,'YYYY')
179: into l_tax_year
180: from dual;
181: hr_utility.set_location('l_tax_year: '||to_char(l_tax_year),20);
182:
183: --
184: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
185: INTO l_tax_year_start_date
183: --
184: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
185: INTO l_tax_year_start_date
186: FROM dual;
187: hr_utility.set_location('l_tax_year_start_date: '||to_char(l_tax_year_start_date),30);
188: --
189: SELECT (add_months(l_tax_year_start_date,
190: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 12) + 1) * 12) -1)
191: INTO p_expiry_information
190: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 12) + 1) * 12) -1)
191: INTO p_expiry_information
192: from dual;
193:
194: hr_utility.set_location('p_expiry_information: '||to_char(p_expiry_information),40);
195: --hr_utility.trace_off;
196: --
197: end ASG_TAX_YTD_EC;
198: --------------------------------- ASG_CAL_YTD_EC --------------------------------------
191: INTO p_expiry_information
192: from dual;
193:
194: hr_utility.set_location('p_expiry_information: '||to_char(p_expiry_information),40);
195: --hr_utility.trace_off;
196: --
197: end ASG_TAX_YTD_EC;
198: --------------------------------- ASG_CAL_YTD_EC --------------------------------------
199: -- NAME