DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PER_TIME_PERIODS

Line 156: ,per_time_periods TPERIOD

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

Line 1937: -- Bug 2715365 Fetch Payroll period start date and end date from per_time_periods table

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;