DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on PER_TIME_PERIODS

Line 1169: from per_time_periods tp,

1165: l_bal_start_date := trunc(l_virtual_date,'Y');
1166: ELSIF p_time_type = 'PTD' THEN
1167: select tp.start_date
1168: into l_bal_start_date
1169: from per_time_periods tp,
1170: per_assignments_f asg
1171: where asg.assignment_id = l_assignment_id
1172: and l_max_date between asg.effective_start_date and effective_end_date
1173: and asg.payroll_id = tp.payroll_id