APPS.HR_PUMP_GET dependencies on PER_PARENT_SPINES

Line 3382: from per_parent_spines pps,

3378: l_grade_rule_id number;
3379: begin
3380: select pgr.grade_rule_id
3381: into l_grade_rule_id
3382: from per_parent_spines pps,
3383: per_spinal_points psp,
3384: pay_grade_rules_f pgr,
3385: pay_rates pr
3386: where pps.name = p_pay_scale

Line 3494: from per_parent_spines pps,

3490: l_spinal_point_id number;
3491: begin
3492: select psp.spinal_point_id
3493: into l_spinal_point_id
3494: from per_parent_spines pps,
3495: per_spinal_points psp
3496: where pps.name = p_pay_scale
3497: and pps.business_group_id + 0 = p_business_group_id
3498: and psp.spinal_point = p_progression_point

Line 3691: from per_parent_spines

3687: l_parent_spine_id number;
3688: begin
3689: select parent_spine_id
3690: into l_parent_spine_id
3691: from per_parent_spines
3692: where name = p_parent_spine
3693: and business_group_id = p_business_group_id;
3694: return(l_parent_spine_id);
3695: exception

Line 4193: from per_parent_spines pps,

4189: l_object_version_number number;
4190: begin
4191: select pgr.object_version_number
4192: into l_object_version_number
4193: from per_parent_spines pps,
4194: per_spinal_points psp,
4195: pay_grade_rules_f pgr,
4196: pay_rates pr
4197: where pps.name = p_pay_scale

Line 4403: from per_parent_spines

4399: l_ovn number;
4400: begin
4401: select object_version_number
4402: into l_ovn
4403: from per_parent_spines
4404: where name = p_pay_scale
4405: and business_group_id + 0 = p_business_group_id;
4406: return(l_ovn);
4407: exception

Line 4447: ,per_parent_spines pps

4443: select pgs.object_version_number
4444: into l_ovn
4445: from per_grade_spines_f pgs
4446: ,per_grades pg
4447: ,per_parent_spines pps
4448: where pg.name = p_grade
4449: and pg.grade_id = pgs.grade_id
4450: and pps.name = p_pay_scale
4451: and pps.parent_spine_id = pgs.parent_spine_id