APPS.BEN_DM_BUSINESS dependencies on BEN_DM_MIGRATIONS

Line 79: update ben_dm_migrations

75: ' to enable a new migration to be started.', 40);
76:
77: else
78:
79: update ben_dm_migrations
80: set status =decode(status,'E','A','C')
81: where migration_id <> r_migration_data.migration_id
82: and status <> 'C';
83: commit;

Line 136: FROM ben_dm_migrations

132: l_status VARCHAR2(30);
133:
134: CURSOR csr_mig_status IS
135: SELECT status
136: FROM ben_dm_migrations
137: WHERE (migration_id = r_migration_data.migration_id);
138:
139: --
140: BEGIN

Line 347: update ben_dm_migrations

343: ' to enable a new migration to be started.', 40);
344:
345: else
346:
347: update ben_dm_migrations
348: set status =decode(status,'E','A','C')
349: where migration_id <> r_migration_data.migration_id
350: and status <> 'C';
351: commit;

Line 411: FROM ben_dm_migrations

407: l_status VARCHAR2(30);
408:
409: CURSOR csr_mig_status IS
410: SELECT status
411: FROM ben_dm_migrations
412: WHERE (migration_id = r_migration_data.migration_id);
413:
414: --
415: BEGIN

Line 485: FROM ben_dm_migrations

481: l_status VARCHAR2(30);
482:
483: CURSOR csr_mig_status IS
484: SELECT status
485: FROM ben_dm_migrations
486: WHERE (migration_id = r_migration_data.migration_id);
487:
488: --
489: BEGIN

Line 568: FROM ben_dm_migrations

564:
565:
566: CURSOR csr_mig_date IS
567: SELECT MAX(effective_date)
568: FROM ben_dm_migrations
569: WHERE (status = 'C');
570: --
571: BEGIN
572: --