APPS.HR_PUMP_GET dependencies on PER_PARENT_SPINES

Line 3409: from per_parent_spines pps,

3405: l_grade_rule_id number;
3406: begin
3407: select pgr.grade_rule_id
3408: into l_grade_rule_id
3409: from per_parent_spines pps,
3410: per_spinal_points psp,
3411: pay_grade_rules_f pgr,
3412: pay_rates pr
3413: where pps.name = p_pay_scale

Line 3521: from per_parent_spines pps,

3517: l_spinal_point_id number;
3518: begin
3519: select psp.spinal_point_id
3520: into l_spinal_point_id
3521: from per_parent_spines pps,
3522: per_spinal_points psp
3523: where pps.name = p_pay_scale
3524: and pps.business_group_id + 0 = p_business_group_id
3525: and psp.spinal_point = p_progression_point

Line 3718: from per_parent_spines

3714: l_parent_spine_id number;
3715: begin
3716: select parent_spine_id
3717: into l_parent_spine_id
3718: from per_parent_spines
3719: where name = p_parent_spine
3720: and business_group_id = p_business_group_id;
3721: return(l_parent_spine_id);
3722: exception

Line 4220: from per_parent_spines pps,

4216: l_object_version_number number;
4217: begin
4218: select pgr.object_version_number
4219: into l_object_version_number
4220: from per_parent_spines pps,
4221: per_spinal_points psp,
4222: pay_grade_rules_f pgr,
4223: pay_rates pr
4224: where pps.name = p_pay_scale

Line 4430: from per_parent_spines

4426: l_ovn number;
4427: begin
4428: select object_version_number
4429: into l_ovn
4430: from per_parent_spines
4431: where name = p_pay_scale
4432: and business_group_id + 0 = p_business_group_id;
4433: return(l_ovn);
4434: exception

Line 4474: ,per_parent_spines pps

4470: select pgs.object_version_number
4471: into l_ovn
4472: from per_grade_spines_f pgs
4473: ,per_grades pg
4474: ,per_parent_spines pps
4475: where pg.name = p_grade
4476: and pg.grade_id = pgs.grade_id
4477: and pps.name = p_pay_scale
4478: and pps.parent_spine_id = pgs.parent_spine_id