DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on AME_ACTIONS

Line 584: from ame_actions act

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

Line 605: ,ame_actions act

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