APPS.PQH_GSP_STAGE_TO_HR dependencies on PER_PARENT_SPINES

Line 650: from per_Parent_spines

646: Where Spinal_Point_Id = P_Point_id;
647:
648: Cursor Csr_Parent_Spine (P_Parent_Spine_Id IN Number) is
649: Select Object_Version_Number
650: from per_Parent_spines
651: Where Parent_spine_Id = P_Parent_Spine_Id;
652:
653: --
654:

Line 656: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;

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

Line 660: l_Prnt_ovn Per_Parent_Spines.Object_Version_Number%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: --
663: --
664: Begin

Line 773: from per_parent_spines scl, pay_rates rt

769: elsif p_scale_id is not null then
770: begin
771: select rt.rate_id
772: into l_rate_id
773: from per_parent_spines scl, pay_rates rt
774: where rt.parent_spine_id = scl.parent_spine_id
775: and scl.parent_spine_id = p_scale_id
776: and rt.rate_type ='SP'
777: and rt.name = scl.name;

Line 2236: (p_table_name => 'PER_PARENT_SPINES',

2232: elsif scl_rec.dml_operation ='UPDATE' and l_scale_id is not null
2233: and scl_rec.information98 is not null and l_scale_ovn is not null then
2234: hr_utility.set_location('scale is being updated'||l_proc,60);
2235: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2236: (p_table_name => 'PER_PARENT_SPINES',
2237: p_key_column_name => 'PARENT_SPINE_ID',
2238: p_key_column_value => l_scale_id);
2239: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2240: if l_db_ovn <> l_scale_ovn then