APPS.HR_MASS_MOVE_API dependencies on PER_MM_ASSIGNMENTS

Line 2008: per_mm_assignments mmasg

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

Line 2032: from per_mm_assignments mm_asg,

2028: asg.vacancy_id,
2029: per.full_name,
2030: org.name orgname,
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,

Line 2326: update per_mm_assignments

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

Line 2506: cursor csr_lock_per_mm_assignments is

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

Line 2508: from per_mm_assignments

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

Line 2717: open csr_lock_per_mm_assignments;

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

Line 2718: close csr_lock_per_mm_assignments;

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