APPS.HR_PUMP_GET dependencies on PER_SPINAL_POINTS

Line 3410: per_spinal_points psp,

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
3414: and pps.business_group_id + 0 = p_business_group_id

Line 3522: per_spinal_points psp

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
3526: and psp.business_group_id + 0 = p_business_group_id

Line 3740: from per_spinal_points psp

3736: l_ceiling_step_id number;
3737: begin
3738: select sps.step_id
3739: into l_ceiling_step_id
3740: from per_spinal_points psp
3741: ,per_spinal_point_steps_f sps
3742: where psp.spinal_point = p_ceiling_point
3743: and psp.spinal_point_id = sps.spinal_point_id
3744: and sps.business_group_id = p_business_group_id

Line 4221: per_spinal_points psp,

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
4225: and pps.business_group_id + 0 = p_business_group_id

Line 4450: from per_spinal_points

4446: l_ovn number;
4447: begin
4448: select object_version_number
4449: into l_ovn
4450: from per_spinal_points
4451: where spinal_point = p_point
4452: and business_group_id + 0 = p_business_group_id;
4453: return(l_ovn);
4454: exception

Line 4502: ,per_spinal_points psp

4498: begin
4499: select sps.object_version_number
4500: into l_ovn
4501: from per_spinal_point_steps_f sps
4502: ,per_spinal_points psp
4503: ,per_grade_spines_f pgs
4504: where psp.spinal_point = p_point
4505: and psp.spinal_point_id = sps.spinal_point_id
4506: and sps.sequence = p_sequence