[Home] [Help]
66: */
67:
68: select time_period_id
69: into l_user_time_period_id
70: from pay_payroll_actions
71: where payroll_action_id = p_user_payroll_action_id;
72:
73: select time_period_id
74: into l_owner_time_period_id
71: where payroll_action_id = p_user_payroll_action_id;
72:
73: select time_period_id
74: into l_owner_time_period_id
75: from pay_payroll_actions
76: where payroll_action_id = p_owner_payroll_action_id;
77:
78: if l_user_time_period_id = l_owner_time_period_id then
79: p_expiry_information := 0;
123: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
124: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
125: into l_tax_year_start, l_user_payroll_id
126: from per_time_periods PTP,
127: pay_payroll_actions BACT
128: where BACT.payroll_action_id = p_user_payroll_action_id
129: and PTP.time_period_id = BACT.time_period_id;
130: --
131: -- find the regular payment date for the owning action
131: -- find the regular payment date for the owning action
132: --
133: select regular_payment_date
134: into l_owning_regular_payment_date
135: from pay_payroll_actions PACT,
136: per_time_periods PTP
137: where PACT.payroll_action_id = p_owner_payroll_action_id
138: and PTP.time_period_id = PACT.time_period_id;
139: --
193: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
194: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
195: into l_tax_year_start, l_user_payroll_id
196: from per_time_periods PTP,
197: pay_payroll_actions BACT
198: where BACT.payroll_action_id = p_user_payroll_action_id
199: and PTP.time_period_id = BACT.time_period_id;
200: --
201: -- find the regular payment date for the owning action
201: -- find the regular payment date for the owning action
202: --
203: select regular_payment_date
204: into l_owning_regular_payment_date
205: from pay_payroll_actions PACT,
206: per_time_periods PTP
207: where PACT.payroll_action_id = p_owner_payroll_action_id
208: and PTP.time_period_id = PACT.time_period_id;
209: --
249: + decode(sign( p_user_effective_date - to_date('06-04-'
250: || to_char( p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
251: -1,-1,0)),'DD-MM-YYYY')
252: into l_tax_year_start
253: from pay_payroll_actions BACT
254: where BACT.payroll_action_id = p_user_payroll_action_id;
255: --
256: if p_owner_effective_date < l_tax_year_start then
257: p_expiry_information := 1;
295:
296: -- find the regular payment date for the using action
297: select regular_payment_date, BACT.business_group_id
298: into l_user_regular_payment_date, l_business_group_id
299: from pay_payroll_actions BACT,
300: per_time_periods PTP
301: where BACT.payroll_action_id = p_user_payroll_action_id
302: and PTP.time_period_id = BACT.time_period_id;
303:
303:
304: -- find the regular payment date for the owning action
305: select regular_payment_date
306: into l_owning_regular_payment_date
307: from pay_payroll_actions PACT,
308: per_time_periods PTP
309: where PACT.payroll_action_id = p_owner_payroll_action_id
310: and PTP.time_period_id = PACT.time_period_id;
311:
383: -1,-1,0),2)
384: ),'DD-MM-YYYY') finyear, BACT.payroll_id
385: into l_tax_year_start, l_user_payroll_id
386: from per_time_periods PTP,
387: pay_payroll_actions BACT
388: where BACT.payroll_action_id = p_user_payroll_action_id
389: and PTP.time_period_id = BACT.time_period_id;
390: --
391: elsif p_dimension_name in ('_ASG_TD_EVEN_TWO_YTD','_PER_TD_EVEN_TWO_YTD') then
403: -1,0,-1),2)
404: ),'DD-MM-YYYY') finyear, BACT.payroll_id
405: into l_tax_year_start, l_user_payroll_id
406: from per_time_periods PTP,
407: pay_payroll_actions BACT
408: where BACT.payroll_action_id = p_user_payroll_action_id
409: and PTP.time_period_id = BACT.time_period_id;
410:
411: end if;
457: -- find the regular payment date for the owning action
458: --
459: select regular_payment_date
460: into l_owning_regular_payment_date
461: from pay_payroll_actions PACT,
462: per_time_periods PTP
463: where PACT.payroll_action_id = p_owner_payroll_action_id
464: and PTP.time_period_id = PACT.time_period_id;
465: --
503: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
504: -1,-1,0)),'DD-MM-YYYY') finyear
505: into l_tax_year_start
506: from per_time_periods PTP,
507: pay_payroll_actions ppa,
508: pay_assignment_actions paa
509: where ppa.payroll_action_id = paa.payroll_action_id
510: and paa.assignment_action_id = p_asg_action
511: and ppa.payroll_id = p_payroll_id
543: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
544: -1,-1,0)),'DD-MM-YYYY') finyear
545: into l_tax_year_start
546: from per_time_periods PTP,
547: pay_payroll_actions ppa,
548: pay_assignment_actions paa
549: where ppa.payroll_action_id = paa.payroll_action_id
550: and paa.assignment_action_id = p_asg_action
551: and ppa.payroll_id = p_payroll_id
594: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
595: -1,-1,0)),'DD-MM-YYYY') finyear
596: into l_tax_year_start
597: from per_time_periods PTP,
598: pay_payroll_actions ppa,
599: pay_assignment_actions paa
600: where ppa.payroll_action_id = paa.payroll_action_id
601: and paa.assignment_action_id = p_asg_action
602: and ppa.payroll_id = p_payroll_id
644: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
645: -1,-1,0)),'DD-MM-YYYY') finyear
646: into l_tax_year_start
647: from per_time_periods PTP,
648: pay_payroll_actions ppa,
649: pay_assignment_actions paa
650: where ppa.payroll_action_id = paa.payroll_action_id
651: and paa.assignment_action_id = p_asg_action
652: and ppa.payroll_id = p_payroll_id