71: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
72: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
73: -1,-1,0)),'DD-MM-YYYY') finyear
74: into l_tax_year_start
75: from per_time_periods PTP,
76: pay_payroll_actions BACT
77: where BACT.payroll_action_id = p_user_payroll_action_id
78: and PTP.time_period_id = BACT.time_period_id;
79:
132: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
133: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
134: -1,-1,0)),'DD-MM-YYYY') finyear
135: into l_tax_year_start
136: from per_time_periods PTP,
137: pay_payroll_actions BACT
138: where BACT.payroll_action_id = p_user_payroll_action_id
139: and PTP.time_period_id = BACT.time_period_id;
140:
170: l_period_start_date date;
171: begin
172: select TP.start_date
173: into l_period_start_date
174: from per_time_periods TP,
175: pay_payroll_actions PACT
176: where PACT.payroll_action_id = p_user_payroll_action_id
177: and PACT.payroll_id = TP.payroll_id
178: and p_user_effective_date between TP.start_date and TP.end_date;
209: l_period_start_date date;
210: begin
211: select TP.start_date
212: into l_period_start_date
213: from per_time_periods TP,
214: pay_payroll_actions PACT
215: where PACT.payroll_action_id = p_user_payroll_action_id
216: and PACT.payroll_id = TP.payroll_id
217: and p_user_effective_date between TP.start_date and TP.end_date;
251: l_period_start_date date;
252: begin
253: select TP.start_date
254: into l_period_start_date
255: from per_time_periods TP,
256: pay_assignment_actions ACT,
257: pay_payroll_actions PACT
258: where ACT.assignment_action_id = p_user_assignment_action_id
259: and ACT.payroll_action_id = PACT.payroll_action_id