620: l_group_id NUMBER;
621:
622: CURSOR csr_phase_items IS
623: SELECT NULL
624: FROM hr_dm_phase_items
625: WHERE phase_id = l_phase_id
626: AND status <> 'C';
627:
628: CURSOR csr_ddp_pi IS
626: AND status <> 'C';
627:
628: CURSOR csr_ddp_pi IS
629: SELECT phase_item_id, group_id
630: FROM hr_dm_phase_items
631: WHERE phase_id = l_phase_id;
632:
633: CURSOR csr_mig_ranges IS
634: SELECT rpi.phase_item_id
631: WHERE phase_id = l_phase_id;
632:
633: CURSOR csr_mig_ranges IS
634: SELECT rpi.phase_item_id
635: FROM hr_dm_phase_items rpi,
636: hr_dm_migration_ranges mr
637: WHERE rpi.group_id = l_group_id
638: AND rpi.phase_id = l_range_phase_id
639: AND rpi.phase_item_id = mr.phase_item_id