DBA Data[Home] [Help]

APPS.PAY_BALANCE_ADJUSTMENT_API dependencies on PER_TIME_PERIODS

Line 141: per_time_periods ptp

137: l_payroll_id,
138: l_time_period_id,
139: l_payroll_action_id
140: from per_assignments_f asg,
141: per_time_periods ptp
142: where asg.assignment_id = p_assignment_id
143: and p_effective_date between
144: asg.effective_start_date and asg.effective_end_date
145: and ptp.payroll_id = asg.payroll_id