DBA Data[Home] [Help]

APPS.PQH_GSP_BEN_VALIDATIONS dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 459: from per_spinal_point_placements_f

455: And nvl(PL.Effective_End_Date, hr_general.end_of_time);
456:
457: cursor csr_point_placement(l_step_id IN Number) is
458: select Effective_Start_date, Effective_End_Date
459: from per_spinal_point_placements_f
460: where step_id = l_step_id
461: And Business_Group_Id= p_business_group_id
462: and p_effective_date between effective_start_date
463: and nvl(effective_end_date,hr_general.end_of_time);