DBA Data[Home] [Help]

APPS.HR_MASS_MOVE_API dependencies on PER_ORGANIZATION_UNITS

Line 2035: per_organization_units org,

2031: neworg.name neworgname
2032: from per_mm_assignments mm_asg,
2033: per_assignments_f asg,
2034: per_people_f per,
2035: per_organization_units org,
2036: per_mass_moves mm,
2037: per_organization_units neworg
2038: where mm_asg.position_id = p_old_position_id
2039: and mm_asg.assignment_id = asg.assignment_id

Line 2037: per_organization_units neworg

2033: per_assignments_f asg,
2034: per_people_f per,
2035: per_organization_units org,
2036: per_mass_moves mm,
2037: per_organization_units neworg
2038: where mm_asg.position_id = p_old_position_id
2039: and mm_asg.assignment_id = asg.assignment_id
2040: and mm_asg.mass_move_id = p_mass_move_id
2041: and mm_asg.mass_move_id = mm.mass_move_id

Line 2537: from per_organization_units

2533: default_end_time,
2534: fnd_number.canonical_to_number(working_hours),
2535: frequency,
2536: location_id
2537: from per_organization_units
2538: where organization_id = l_new_organization_id;
2539: --
2540: cursor csr_get_busgrp_defaults is
2541: select legislation_code,