APPS.PQH_GSP_STAGE_TO_HR dependencies on PER_PARENT_SPINES

Line 683: from per_Parent_spines

679: Where Spinal_Point_Id = P_Point_id;
680:
681: Cursor Csr_Parent_Spine (P_Parent_Spine_Id IN Number) is
682: Select Object_Version_Number
683: from per_Parent_spines
684: Where Parent_spine_Id = P_Parent_Spine_Id;
685:
686: --
687:

Line 689: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;

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;
693: l_Prnt_ovn Per_Parent_Spines.Object_Version_Number%TYPE;

Line 693: l_Prnt_ovn Per_Parent_Spines.Object_Version_Number%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: --
696: --
697: Begin

Line 812: from per_parent_spines scl, pay_rates rt

808: elsif p_scale_id is not null then
809: begin
810: select rt.rate_id
811: into l_rate_id
812: from per_parent_spines scl, pay_rates rt
813: where rt.parent_spine_id = scl.parent_spine_id
814: and scl.parent_spine_id = p_scale_id
815: and rt.rate_type ='SP'
816: and rt.name = scl.name;

Line 2276: (p_table_name => 'PER_PARENT_SPINES',

2272: elsif scl_rec.dml_operation ='UPDATE' and l_scale_id is not null
2273: and scl_rec.information98 is not null and l_scale_ovn is not null then
2274: hr_utility.set_location('scale is being updated'||l_proc,60);
2275: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2276: (p_table_name => 'PER_PARENT_SPINES',
2277: p_key_column_name => 'PARENT_SPINE_ID',
2278: p_key_column_value => l_scale_id);
2279: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2280: if l_db_ovn <> l_scale_ovn then