DBA Data[Home] [Help]

APPS.AME_RULE_USAGES_API2 dependencies on AME_ACTION_TYPES

Line 326: ame_action_types aat

322: aa.parameter
323: from ame_rule_usages aru,
324: ame_action_usages aau,
325: ame_actions aa,
326: ame_action_types aat
327: where aru.rule_id = x_rule_id
328: and aru.item_id = x_application_id
329: and sysdate between aat.start_date and nvl(aat.end_date,sysdate)
330: and sysdate between aa.start_date and nvl(aa.end_date,sysdate)

Line 340: from ame_action_types

336: and aau.action_id = aa.action_id
337: and aa.action_type_id = aat.action_type_id;
338: cursor group_action_type_cursor(c_action_type_id integer) is
339: select null
340: from ame_action_types
341: where sysdate between start_date and nvl(end_date,sysdate)
342: and action_type_id = c_action_type_id
343: and name in ('pre-chain-of-authority approvals'
344: ,'post-chain-of-authority approvals'