DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on PER_POSITIONS

Line 2567: FROM per_positions pos,

2563: IS
2564: CURSOR csr_positions
2565: IS
2566: SELECT pos.name
2567: FROM per_positions pos,
2568: per_assignments_f asg
2569: WHERE pos.position_id = asg.position_id
2570: AND asg.assignment_id = p_assignment_id
2571: AND p_effective_date BETWEEN asg.effective_start_date

Line 2574: l_position per_positions.name%TYPE;

2570: AND asg.assignment_id = p_assignment_id
2571: AND p_effective_date BETWEEN asg.effective_start_date
2572: AND asg.effective_end_date;
2573:
2574: l_position per_positions.name%TYPE;
2575:
2576: BEGIN
2577: OPEN csr_positions;
2578: FETCH csr_positions INTO l_position;