DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PER_TIME_PERIODS

Line 155: ,per_time_periods TPERIOD

151: ,TPERIOD.end_date
152: ,PACTION.payroll_action_id
153: from pay_payroll_actions PACTION
154: ,pay_assignment_actions ASSACTION
155: ,per_time_periods TPERIOD
156: ,per_time_period_types TPTYPE
157: where ASSACTION.assignment_action_id = p_asg_action_id
158: and PACTION.payroll_action_id = ASSACTION.payroll_action_id
159: and TPERIOD.time_period_id = PACTION.time_period_id

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

1943: BEGIN
1944: if g_debug then
1945: hr_utility.set_location('---------Entering pay_kr_wg_pkg.calc_wage_garnishment--------',10);
1946: end if;
1947: -- Bug 2715365 Fetch Payroll period start date and end date from per_time_periods table
1948:
1949: -- Bug : 4498363
1950: OPEN csr_get_global_values('KR_WG_MIN_UNDEDUCTABLE_AMOUNT',p_date_paid);
1951: FETCH csr_get_global_values into g_min_undeduct_amt;