[Home] [Help]
122: /* select ptp.start_date,
123: ptp.regular_payment_date
124: into l_period_start,
125: l_period_end
126: from per_time_periods ptp
127: where ptp.time_period_id = p_period_id;*/
128:
129: if p_dimension_id = p_ptd_bal_dim_id then
130: if (l_time_period_id=p_period_id) then
252: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
253: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
254: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
255: from
256: per_time_periods PTP,
257: pay_payroll_actions BACT,
258: pay_assignment_actions ACT
259: where PTP.time_period_id = BACT.time_period_id
260: and ACT.assignment_action_id = c_assignment_action_id
277: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
278: -1,-1,0),2)
279: ),'DD-MM-YYYY') finyear, BACT.payroll_id
280: FROM
281: per_time_periods PTP,
282: pay_payroll_actions BACT,
283: pay_assignment_actions ACT
284: WHERE PTP.time_period_id = BACT.time_period_id
285: AND ACT.assignment_action_id = c_assignment_action_id
302: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
303: -1,0,-1),2)
304: ),'DD-MM-YYYY') finyear, BACT.payroll_id
305: FROM
306: per_time_periods PTP,
307: pay_payroll_actions BACT,
308: pay_assignment_actions ACT
309: WHERE PTP.time_period_id = BACT.time_period_id
310: AND ACT.assignment_action_id = c_assignment_action_id
313: --
314: cursor csr_start_pay_yr(c_tax_yr_start in date,
315: c_payroll_id in number) is
316: select min(TP.start_date)
317: from per_time_periods TP
318: where TP.payroll_id = c_payroll_id
319: and TP.regular_payment_date >= c_tax_yr_start;
320: --
321: l_year_add_no NUMBER;
401: l_end_date DATE;
402: --
403: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
404: select ptp.end_date
405: from per_time_periods ptp,
406: pay_payroll_actions ppa,
407: pay_assignment_actions paa
408: WHERE
409: paa.assignment_action_id = c_assignment_action_id