DBA Data[Home] [Help]

APPS.HR_AU_PERSONAL_PAY_METHOD_API dependencies on PER_ASSIGNMENTS_F

Line 76: per_assignments_f asg

72: --
73: CURSOR legsel IS
74: SELECT pbg.legislation_code
75: FROM per_business_groups pbg,
76: per_assignments_f asg
77: WHERE pbg.business_group_id = asg.business_group_id
78: AND asg.assignment_id = p_assignment_id
79: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
80: --