DBA Data[Home] [Help]

APPS.AME_RULE_USAGES_API dependencies on AME_ACTION_TYPES

Line 309: ame_action_types aat

305: aa.parameter
306: from ame_rule_usages aru,
307: ame_action_usages aau,
308: ame_actions aa,
309: ame_action_types aat
310: where aru.rule_id = x_rule_id
311: and aru.item_id = x_application_id
312: and sysdate between aat.start_date and nvl(aat.end_date,sysdate)
313: and sysdate between aa.start_date and nvl(aa.end_date,sysdate)

Line 323: from ame_action_types

319: and aau.action_id = aa.action_id
320: and aa.action_type_id = aat.action_type_id;
321: cursor group_action_type_cursor(c_action_type_id integer) is
322: select null
323: from ame_action_types
324: where sysdate between start_date and nvl(end_date,sysdate)
325: and action_type_id = c_action_type_id
326: and name in ('pre-chain-of-authority approvals'
327: ,'post-chain-of-authority approvals'