DBA Data[Home] [Help]

APPS.HR_IN_PERSONAL_PAY_METHOD_API dependencies on PER_ASSIGNMENTS_F

Line 69: per_assignments_f asg

65:
66: CURSOR legsel (p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
67: SELECT pbg.legislation_code
68: FROM per_business_groups pbg,
69: per_assignments_f asg
70: WHERE pbg.business_group_id = asg.business_group_id
71: AND asg.assignment_id = p_assignment_id
72: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;
73: