DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on PER_TIME_PERIODS

Line 1100: from per_time_periods tp,

1096: l_bal_start_date := trunc(l_virtual_date,'Y');
1097: ELSIF p_time_type = 'PTD' THEN
1098: select tp.start_date
1099: into l_bal_start_date
1100: from per_time_periods tp,
1101: per_assignments_f asg
1102: where asg.assignment_id = l_assignment_id
1103: and l_max_date between asg.effective_start_date and effective_end_date
1104: and asg.payroll_id = tp.payroll_id