DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PER_TIME_PERIODS

Line 2216: from per_time_periods tp,

2212: l_bal_start_date := trunc(l_virtual_date,'Y');
2213: ELSIF p_time_type = 'PTD' THEN
2214: select tp.start_date
2215: into l_bal_start_date
2216: from per_time_periods tp,
2217: per_assignments_f asg
2218: where asg.assignment_id = l_assignment_id
2219: and l_max_date between asg.effective_start_date and effective_end_date
2220: and asg.payroll_id = tp.payroll_id