DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on AME_ACTIONS

Line 582: from ame_actions act

578: Cursor C_Sel2 is
579: select act.action_id
580: ,act.action_type_id
581: ,act.object_version_number
582: from ame_actions act
583: ,ame_action_types aty
584: where aty.name in ( ame_util.preApprovalTypeName
585: ,ame_util.postApprovalTypeName
586: ,ame_util.groupChainApprovalTypeName

Line 603: ,ame_actions act

599: --cursor to find the number of rules using the group(01-03-2005)
600: cursor CSel4 is
601: select count(*)
602: from ame_action_usages actu
603: ,ame_actions act
604: ,ame_action_types acty
605: where act.parameter = to_char(p_approval_group_id)
606: and actu.action_id = act.action_id
607: and act.action_type_id = acty.action_type_id