DBA Data[Home] [Help]

APPS.BEN_DM_INIT dependencies on HR_DM_PHASE_RULES

Line 489: FROM hr_dm_phase_rules

485: l_database_location VARCHAR2(30);
486:
487: CURSOR csr_phase_rule IS
488: SELECT phase_name, previous_phase, next_phase, database_location
489: FROM hr_dm_phase_rules
490: WHERE ((migration_type = 'SP')
491: AND (previous_phase = l_search_phase))
492: AND database_location = r_migration_data.database_location;
493: --

Line 635: FROM hr_dm_phase_rules

631: l_database_location VARCHAR2(30);
632:
633: CURSOR csr_phase_rule IS
634: SELECT phase_name, database_location
635: FROM hr_dm_phase_rules
636: WHERE ((migration_type = 'SP')
637: AND database_location = r_migration_data.database_location);
638: -- AND (INSTR(database_location,
639: -- r_migration_data.database_location) >0));