APPS.AME_MIGRATE_PARALLEL_CONFIG dependencies on AME_APPROVAL_GROUP_CONFIG

Line 29: from ame_approval_group_config aagc

25:
26: cursor unused_group_config_cursor is
27: select aagc.application_id,
28: aagc.approval_group_id
29: from ame_approval_group_config aagc
30: where sysdate between aagc.start_date
31: and nvl(aagc.end_date - (1/86400),sysdate)
32: and not exists
33: (select null

Line 80: update ame_approval_group_config master_cfg

76: l_approval_group_id;
77:
78: exit when unused_group_config_cursor%notfound;
79:
80: update ame_approval_group_config master_cfg
81: set master_cfg.end_date = l_migration_date
82: where sysdate between master_cfg.start_date
83: and nvl(master_cfg.end_date - (1/86400),sysdate)
84: and master_cfg.application_id = l_application_id