APPS.HR_DM_BUSINESS dependencies on HR_DM_MIGRATIONS

Line 180: FROM hr_dm_migrations

176: l_mig_count NUMBER;
177:
178: CURSOR csr_mig_count IS
179: SELECT count(*)
180: FROM hr_dm_migrations
181: WHERE status IN ('S', 'NS', 'E');
182:
183: --
184: BEGIN

Line 259: FROM hr_dm_migrations

255: l_status VARCHAR2(30);
256:
257: CURSOR csr_mig_status IS
258: SELECT status
259: FROM hr_dm_migrations
260: WHERE (migration_id = r_migration_data.migration_id);
261:
262: --
263: BEGIN

Line 574: FROM hr_dm_migrations

570: l_business_group_id NUMBER;
571:
572: CURSOR csr_mig_info IS
573: SELECT business_group_created
574: FROM hr_dm_migrations
575: WHERE (migration_id = r_migration_data.migration_id);
576:
577: CURSOR csr_biz_grp IS
578: SELECT business_group_id

Line 685: FROM hr_dm_migrations

681: l_mig_count NUMBER;
682:
683: CURSOR csr_mig_count IS
684: SELECT count(*)
685: FROM hr_dm_migrations
686: WHERE status IN ('S', 'NS', 'E');
687:
688: --
689: BEGIN

Line 772: FROM hr_dm_migrations

768: l_status VARCHAR2(30);
769:
770: CURSOR csr_mig_status IS
771: SELECT status
772: FROM hr_dm_migrations
773: WHERE (migration_id = r_migration_data.migration_id);
774:
775: --
776: BEGIN

Line 846: FROM hr_dm_migrations

842: l_status VARCHAR2(30);
843:
844: CURSOR csr_mig_status IS
845: SELECT status
846: FROM hr_dm_migrations
847: WHERE (migration_id = r_migration_data.migration_id);
848:
849: --
850: BEGIN

Line 937: FROM hr_dm_migrations

933:
934:
935: CURSOR csr_mig_info IS
936: SELECT business_group_id
937: FROM hr_dm_migrations
938: WHERE (migration_id = r_migration_data.migration_id)
939: AND (UPPER(source_database_instance) =
940: UPPER(r_migration_data.source_database_instance))
941: AND (UPPER(destination_database_instance) =

Line 946: FROM hr_dm_migrations

942: UPPER(r_migration_data.destination_database_instance));
943:
944: CURSOR csr_mig_date IS
945: SELECT MAX(effective_date)
946: FROM hr_dm_migrations
947: WHERE (status = 'F')
948: AND (business_group_id = l_business_group_id)
949: AND (migration_type = 'FW')
950: AND

Line 971: FROM hr_dm_migrations

967: );
968:
969: CURSOR csr_mig_date_othr IS
970: SELECT MAX(effective_date)
971: FROM hr_dm_migrations
972: WHERE (status = 'F')
973: AND (business_group_id = l_business_group_id)
974: AND (migration_type = l_migration_type_test)
975: AND (effective_date > NVL(l_last_fw_date,

Line 1126: FROM hr_dm_migrations

1122: l_destination_instance VARCHAR2(30);
1123:
1124: CURSOR csr_mig_info IS
1125: SELECT source_database_instance, destination_database_instance
1126: FROM hr_dm_migrations
1127: WHERE (migration_id = r_migration_data.migration_id);
1128:
1129:
1130: --