APPS.HR_MASS_MOVE_API dependencies on PER_MM_ASSIGNMENTS

Line 2010: per_mm_assignments mmasg

2006: cursor csr_future_asg_changes is
2007: select null
2008: from per_assignments_f asg,
2009: per_mass_moves mm,
2010: per_mm_assignments mmasg
2011: where mmasg.assignment_id = l_mm_assignment_id
2012: and asg.assignment_id = mmasg.assignment_id
2013: and mmasg.mass_move_id = p_mass_move_id
2014: and mmasg.mass_move_id = mm.mass_move_id

Line 2034: from per_mm_assignments mm_asg,

2030: asg.vacancy_id,
2031: per.full_name,
2032: org.name orgname,
2033: neworg.name neworgname
2034: from per_mm_assignments mm_asg,
2035: per_assignments_f asg,
2036: per_people_f per,
2037: per_organization_units org,
2038: per_mass_moves mm,

Line 2328: update per_mm_assignments

2324: --
2325: --
2326: -- if it has made it this far, the applicant/employee assignment was moved
2327: --
2328: update per_mm_assignments
2329: set assignment_moved = 'Y'
2330: where assignment_id = mmasgrec.assignment_id
2331: and mass_move_id = p_mass_move_id;
2332: --

Line 2508: cursor csr_lock_per_mm_assignments is

2504: from per_mm_positions
2505: where mass_move_id = p_mass_move_id
2506: for update nowait;
2507: --
2508: cursor csr_lock_per_mm_assignments is
2509: select null
2510: from per_mm_assignments
2511: where mass_move_id = p_mass_move_id
2512: for update nowait;

Line 2510: from per_mm_assignments

2506: for update nowait;
2507: --
2508: cursor csr_lock_per_mm_assignments is
2509: select null
2510: from per_mm_assignments
2511: where mass_move_id = p_mass_move_id
2512: for update nowait;
2513: --
2514: cursor csr_lock_per_mm_valid_grades is

Line 2719: open csr_lock_per_mm_assignments;

2715: open csr_lock_per_mass_moves;
2716: close csr_lock_per_mass_moves;
2717: open csr_lock_per_mm_positions;
2718: close csr_lock_per_mm_positions;
2719: open csr_lock_per_mm_assignments;
2720: close csr_lock_per_mm_assignments;
2721: open csr_lock_per_mm_valid_grades;
2722: close csr_lock_per_mm_valid_grades;
2723: open csr_lock_per_mm_job_reqts;

Line 2720: close csr_lock_per_mm_assignments;

2716: close csr_lock_per_mass_moves;
2717: open csr_lock_per_mm_positions;
2718: close csr_lock_per_mm_positions;
2719: open csr_lock_per_mm_assignments;
2720: close csr_lock_per_mm_assignments;
2721: open csr_lock_per_mm_valid_grades;
2722: close csr_lock_per_mm_valid_grades;
2723: open csr_lock_per_mm_job_reqts;
2724: close csr_lock_per_mm_job_reqts;