DBA Data[Home] [Help]

APPS.HR_DM_MASTER dependencies on HR_DM_PHASE_ITEMS

Line 624: FROM hr_dm_phase_items

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

Line 630: FROM hr_dm_phase_items

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

Line 635: FROM hr_dm_phase_items rpi,

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