APPS.HR_PUMP_GET dependencies on PER_SPINAL_POINTS

Line 3383: per_spinal_points psp,

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

Line 3495: per_spinal_points psp

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

Line 3713: from per_spinal_points psp

3709: l_ceiling_step_id number;
3710: begin
3711: select sps.step_id
3712: into l_ceiling_step_id
3713: from per_spinal_points psp
3714: ,per_spinal_point_steps_f sps
3715: where psp.spinal_point = p_ceiling_point
3716: and psp.spinal_point_id = sps.spinal_point_id
3717: and sps.business_group_id = p_business_group_id

Line 4194: per_spinal_points psp,

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

Line 4423: from per_spinal_points

4419: l_ovn number;
4420: begin
4421: select object_version_number
4422: into l_ovn
4423: from per_spinal_points
4424: where spinal_point = p_point
4425: and business_group_id + 0 = p_business_group_id;
4426: return(l_ovn);
4427: exception

Line 4475: ,per_spinal_points psp

4471: begin
4472: select sps.object_version_number
4473: into l_ovn
4474: from per_spinal_point_steps_f sps
4475: ,per_spinal_points psp
4476: ,per_grade_spines_f pgs
4477: where psp.spinal_point = p_point
4478: and psp.spinal_point_id = sps.spinal_point_id
4479: and sps.sequence = p_sequence