DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PER_TIME_PERIODS

Line 1978: from per_time_periods tp,

1974: l_bal_start_date := trunc(l_virtual_date,'Y');
1975: ELSIF p_time_type = 'PTD' THEN
1976: select tp.start_date
1977: into l_bal_start_date
1978: from per_time_periods tp,
1979: per_assignments_f asg
1980: where asg.assignment_id = l_assignment_id
1981: and l_max_date between asg.effective_start_date and effective_end_date
1982: and asg.payroll_id = tp.payroll_id