APPS.AME_ACTIONS_API dependencies on AME_ACTION_TYPES

Line 30: from AME_ACTION_TYPES

26: (
27: X_ACTION_TYPE_NAME in VARCHAR2
28: ) is
29: select ACTION_TYPE_ID
30: from AME_ACTION_TYPES
31: where NAME = X_ACTION_TYPE_NAME
32: and sysdate between START_DATE
33: and nvl(END_DATE - (1/86400), sysdate);
34: cursor CSR_GET_CURRENT_ACTION

Line 534: AME_ACTION_TYPES AAT

530: X_CREATED_BY,
531: X_ACTION_ID
532: from AME_ACTIONS_TL ACTTL,
533: AME_ACTIONS ACT,
534: AME_ACTION_TYPES AAT
535: where AAT.NAME = X_ACTION_TYPE_NAME
536: and AAT.ACTION_TYPE_ID = ACT.ACTION_TYPE_ID
537: and nvl(ACT.PARAMETER,'NULL') = nvl(X_TEMP_PARAMETER,'NULL')
538: and nvl(ACT.PARAMETER_TWO,'NULL') = nvl(X_PARAMETER_TWO,'NULL')

Line 547: from ame_actions aac,ame_action_types aaty

543: and (X_ACTION_TYPE_NAME <> ame_util.finalAuthorityTypeName
544: or (X_ACTION_TYPE_NAME = ame_util.finalAuthorityTypeName and
545: ACT.ACTION_ID = (
546: select MIN(ACTION_ID)
547: from ame_actions aac,ame_action_types aaty
548: where aac.action_type_id = aaty.action_type_id
549: and aaty.name = X_ACTION_TYPE_NAME
550: and sysdate between aac.start_date
551: and nvl(aac.end_date,sysdate)