APPS.AME_MIGRATION_REPORT dependencies on AME_ACTION_TYPES

Line 182: from ame_action_types acty

178: --
179: cursor customHandlers is
180: select acty.name,
181: acty.procedure_name
182: from ame_action_types acty
183: where acty.created_by <> 1 and
184: not exists (select null
185: from ame_action_types
186: where procedure_name = acty.procedure_name and

Line 185: from ame_action_types

181: acty.procedure_name
182: from ame_action_types acty
183: where acty.created_by <> 1 and
184: not exists (select null
185: from ame_action_types
186: where procedure_name = acty.procedure_name and
187: created_by = 1 and
188: sysdate between start_date and
189: nvl(end_date - (ame_util.oneSecond), sysdate)) and

Line 200: ame_action_types acty

196: select acty.name action_type
197: ,act.description action
198: ,act.parameter source_attribute
199: from ame_actions act,
200: ame_action_types acty
201: where act.action_type_id = acty.action_type_id and
202: acty.name in (dynamicPreApprover, dynamicPostApprover) and
203: sysdate between act.start_date and nvl(act.end_date - (ame_util.oneSecond), sysdate) and
204: sysdate between acty.start_date and nvl(acty.end_date - (ame_util.oneSecond), sysdate);

Line 510: from ame_action_types

506: select distinct action_id, substrb(parameter, instrb(parameter,':')+1) person_id, description
507: from ame_actions
508: where parameter like 'person_id:%'
509: and exists (select null
510: from ame_action_types
511: where name = ame_util.substitutionTypeName
512: and action_type_id = ame_actions.action_type_id
513: and rownum < 2)
514: and not exists (select null

Line 661: from ame_action_types

657: select distinct action_id, substrb(parameter, instrb(parameter,'AME_MIGRATION_')+14) person_id, description
658: from ame_actions
659: where parameter like 'AME_MIGRATION%'
660: and exists (select null
661: from ame_action_types
662: where name = ame_util.substitutionTypeName
663: and action_type_id = ame_actions.action_type_id
664: and rownum < 2)
665: and exists (select null

Line 792: from ame_action_types

788: where parameter like 'user_id:%'
789: and fnd.employee_id is not null
790: and substrb(parameter, instrb(parameter,':')+1) = to_char(fnd.user_id)
791: and exists (select null
792: from ame_action_types
793: where name = ame_util.substitutionTypeName
794: and action_type_id = ame_actions.action_type_id
795: and rownum < 2);
796: begin