APPS.PQH_GSP_STAGE_TO_HR dependencies on PER_SPINAL_POINTS

Line 635: and Mapping_table_name = 'PER_SPINAL_POINTS';

631: From Ben_opt_F
632: Where opt_id = p_opt_id
633: and p_effective_date
634: between Effective_Start_Date and Effective_End_Date
635: and Mapping_table_name = 'PER_SPINAL_POINTS';
636:
637:
638: Cursor Csr_Spinal_Point (P_Point_id IN Number) is
639: Select parent_spine_Id, Object_version_Number

Line 640: from Per_Spinal_Points

636:
637:
638: Cursor Csr_Spinal_Point (P_Point_id IN Number) is
639: Select parent_spine_Id, Object_version_Number
640: from Per_Spinal_Points
641: Where Spinal_Point_Id = P_Point_id;
642:
643: Cursor Csr_Step (P_Point_id IN Number) Is
644: Select Step_id

Line 655: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;

651: Where Parent_spine_Id = P_Parent_Spine_Id;
652:
653: --
654:
655: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;
656: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;
657: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
658: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;
659: L_Spinal_Cnt Number;

Line 658: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;

654:
655: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;
656: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;
657: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
658: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;
659: L_Spinal_Cnt Number;
660: l_Prnt_ovn Per_Parent_Spines.Object_Version_Number%TYPE;
661: --
662: --

Line 706: From Per_Spinal_Points

702:
703: hr_utility.set_location('Progression Points deleted' || l_Point_Id ,20);
704:
705: Select Count(Spinal_Point_Id) into L_Spinal_Cnt
706: From Per_Spinal_Points
707: where Parent_Spine_Id = l_Parent_Spine_Id;
708:
709: If l_Spinal_Cnt = 0 Then
710: -- Delete The Pay Scale also

Line 1844: (p_table_name => 'PER_SPINAL_POINTS',

1840: and point_rec.information257 is not null
1841: and point_rec.information255 is not null then
1842: hr_utility.set_location('going for upd',30);
1843: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1844: (p_table_name => 'PER_SPINAL_POINTS',
1845: p_key_column_name => 'SPINAL_POINT_ID',
1846: p_key_column_value => l_point_id);
1847: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1848: if l_db_ovn <> l_point_ovn then