DBA Data[Home] [Help]

APPS.PAY_JP_BALANCE_VIEW_PKG dependencies on PER_TIME_PERIODS

Line 45: per_time_periods ptp

41: into l_assignment_rec.business_group_id,
42: l_assignment_rec.payroll_id,
43: l_assignment_rec.time_period_id
44: from per_all_assignments_f asg,
45: per_time_periods ptp
46: where asg.assignment_id = p_assignment_id
47: and p_effective_date
48: between asg.effective_start_date and asg.effective_end_date
49: and ptp.payroll_id(+) = asg.payroll_id