APPS.PAY_IN_UTILS dependencies on PER_POSITIONS

Line 2552: FROM per_positions pos,

2548: IS
2549: CURSOR csr_positions
2550: IS
2551: SELECT pos.name
2552: FROM per_positions pos,
2553: per_assignments_f asg
2554: WHERE pos.position_id = asg.position_id
2555: AND asg.assignment_id = p_assignment_id
2556: AND p_effective_date BETWEEN asg.effective_start_date

Line 2559: l_position per_positions.name%TYPE;

2555: AND asg.assignment_id = p_assignment_id
2556: AND p_effective_date BETWEEN asg.effective_start_date
2557: AND asg.effective_end_date;
2558:
2559: l_position per_positions.name%TYPE;
2560:
2561: BEGIN
2562: OPEN csr_positions;
2563: FETCH csr_positions INTO l_position;