152: ,TPERIOD.end_date
153: ,PACTION.payroll_action_id
154: from pay_payroll_actions PACTION
155: ,pay_assignment_actions ASSACTION
156: ,per_time_periods TPERIOD
157: ,per_time_period_types TPTYPE
158: where ASSACTION.assignment_action_id = p_asg_action_id
159: and PACTION.payroll_action_id = ASSACTION.payroll_action_id
160: and TPERIOD.time_period_id = PACTION.time_period_id
1933: BEGIN
1934: if g_debug then
1935: hr_utility.set_location('---------Entering pay_kr_wg_pkg.calc_wage_garnishment--------',10);
1936: end if;
1937: -- Bug 2715365 Fetch Payroll period start date and end date from per_time_periods table
1938:
1939: OPEN csr_pay_period(p_assignment_action_id);
1940: FETCH csr_pay_period INTO l_period_start_date, l_period_end_date, l_payroll_action_id;
1941: CLOSE csr_pay_period;