DBA Data[Home] [Help]

APPS.HRSPINE dependencies on PER_PERIODS_OF_SERVICE

Line 1485: per_periods_of_service pps --12727056

1481: per_spinal_point_steps_f sps1,
1482: per_spinal_points psp,
1483: per_spinal_point_steps_f sps,
1484: per_spinal_point_placements_f spp,
1485: per_periods_of_service pps --12727056
1486: WHERE (p_parent_spine_id is null -- PARENT_SPINE_ID
1487: OR
1488: (spp.parent_spine_id is not null
1489: and spp.parent_spine_id = P_Parent_Spine_ID))

Line 1746: per_periods_of_service pos,

1742: pap.original_date_of_hire,
1743: pos.adjusted_svc_date,
1744: paa.payroll_id
1745: from per_all_people_f pap,
1746: per_periods_of_service pos,
1747: per_all_assignments_f paa,
1748: per_spinal_point_placements_f spp
1749: where spp.assignment_id = paa.assignment_id
1750: and paa.person_id = pap.person_id