APPS.PQH_FR_SPEED dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 238: FROM per_spinal_point_placements_f

234: --
235: --Cursor to fetch total people (fonctionaires only) in specified Speed within the Corps and Grade
236: CURSOR csr_tot_ppl_in_speed IS
237: SELECT COUNT(placement_id)
238: FROM per_spinal_point_placements_f
239: WHERE assignment_id IN (SELECT asg.assignment_id
240: FROM per_all_assignments_f asg
241: ,per_all_people_f ppl
242: WHERE asg.grade_ladder_pgm_id = p_ben_pgm_id

Line 367: ,'PER_SPINAL_POINT_PLACEMENTS_F'

363: --
364: HR_UTILITY.set_location('OVN before update: '||l_ovn,20);
365: --
366: l_datetrack_mode := PQH_FR_UTILITY.get_datetrack_mode(p_eff_dt
367: ,'PER_SPINAL_POINT_PLACEMENTS_F'
368: ,'PLACEMENT_ID'
369: ,p_place_id);
370: --
371: HR_UTILITY.set_location('l_datetrack_mode: '||l_datetrack_mode,30);

Line 504: ,per_spinal_point_placements_f spp

500: ,MONTHS_BETWEEN(p_effective_date,spp.effective_start_date)
501: ,p_effective_date-spp.effective_start_date
502: ,spp.effective_start_date
503: FROM per_all_assignments_f asg
504: ,per_spinal_point_placements_f spp
505: WHERE asg.assignment_id = p_assignment_id
506: AND spp.assignment_id(+) = asg.assignment_id
507: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
508: AND p_effective_date BETWEEN spp.effective_start_date(+) AND spp.effective_end_date(+);