APPS.PQH_GSP_STAGE_TO_HR dependencies on PER_SPINAL_POINTS

Line 668: and Mapping_table_name = 'PER_SPINAL_POINTS';

664: From Ben_opt_F
665: Where opt_id = p_opt_id
666: and p_effective_date
667: between Effective_Start_Date and Effective_End_Date
668: and Mapping_table_name = 'PER_SPINAL_POINTS';
669:
670:
671: Cursor Csr_Spinal_Point (P_Point_id IN Number) is
672: Select parent_spine_Id, Object_version_Number

Line 673: from Per_Spinal_Points

669:
670:
671: Cursor Csr_Spinal_Point (P_Point_id IN Number) is
672: Select parent_spine_Id, Object_version_Number
673: from Per_Spinal_Points
674: Where Spinal_Point_Id = P_Point_id;
675:
676: Cursor Csr_Step (P_Point_id IN Number) Is
677: Select Step_id

Line 688: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;

684: Where Parent_spine_Id = P_Parent_Spine_Id;
685:
686: --
687:
688: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;
689: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;
690: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
691: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;
692: L_Spinal_Cnt Number;

Line 691: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;

687:
688: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;
689: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;
690: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
691: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;
692: L_Spinal_Cnt Number;
693: l_Prnt_ovn Per_Parent_Spines.Object_Version_Number%TYPE;
694: --
695: --

Line 744: From Per_Spinal_Points

740:
741: hr_utility.set_location('Progression Points deleted' || l_Point_Id ,20);
742:
743: Select Count(Spinal_Point_Id) into L_Spinal_Cnt
744: From Per_Spinal_Points
745: where Parent_Spine_Id = l_Parent_Spine_Id;
746:
747: If l_Spinal_Cnt = 0 Then
748: -- Delete The Pay Scale also

Line 1883: (p_table_name => 'PER_SPINAL_POINTS',

1879: and point_rec.information257 is not null
1880: and point_rec.information255 is not null then
1881: hr_utility.set_location('going for upd',30);
1882: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1883: (p_table_name => 'PER_SPINAL_POINTS',
1884: p_key_column_name => 'SPINAL_POINT_ID',
1885: p_key_column_value => l_point_id);
1886: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1887: if l_db_ovn <> l_point_ovn then