APPS.HR_MASS_MOVE_API dependencies on PER_MM_VALID_GRADES

Line 1044: from per_mm_valid_grades mmvgr

1040: ,mmvgr.attribute17
1041: ,mmvgr.attribute18
1042: ,mmvgr.attribute19
1043: ,mmvgr.attribute20
1044: from per_mm_valid_grades mmvgr
1045: where mmvgr.mass_move_id = p_mass_move_id
1046: and mmvgr.position_id = p_position_id
1047: and not exists
1048: (select vgr.grade_id

Line 2514: cursor csr_lock_per_mm_valid_grades is

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
2515: select null
2516: from per_mm_valid_grades
2517: where mass_move_id = p_mass_move_id
2518: for update nowait;

Line 2516: from per_mm_valid_grades

2512: for update nowait;
2513: --
2514: cursor csr_lock_per_mm_valid_grades is
2515: select null
2516: from per_mm_valid_grades
2517: where mass_move_id = p_mass_move_id
2518: for update nowait;
2519: --
2520: cursor csr_lock_per_mm_job_reqts is

Line 2600: from per_mm_valid_grades mmvgr

2596: mmvgr.attribute17,
2597: mmvgr.attribute18,
2598: mmvgr.attribute19,
2599: mmvgr.attribute20
2600: from per_mm_valid_grades mmvgr
2601: where mmvgr.mass_move_id = p_mass_move_id;
2602:
2603: --
2604: cursor csr_get_mm_positions is

Line 2721: open csr_lock_per_mm_valid_grades;

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;
2725: --

Line 2722: close csr_lock_per_mm_valid_grades;

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;
2725: --
2726: hr_utility.set_location(l_proc, 30);