APPS.HR_NZ_PERSONAL_PAY_METHOD_API dependencies on PER_ASSIGNMENTS_F
Line 27: per_assignments_f asg
23: --
24: CURSOR csr_legcode IS
25: SELECT pbg.legislation_code
26: FROM per_business_groups pbg, 27: per_assignments_f asg 28: WHERE pbg.business_group_id = asg.business_group_id
29: AND asg.assignment_id = p_assignment_id
30: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
31: