DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on AME_ACTION_TYPES

Line 214: from ame_action_types

210: --
211: Cursor C_Sel1 is
212: select action_type_id
213: ,name
214: from ame_action_types
215: where name in ( ame_util.preApprovalTypeName
216: ,ame_util.postApprovalTypeName
217: ,ame_util.groupChainApprovalTypeName
218: )

Line 583: ,ame_action_types aty

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
587: )

Line 604: ,ame_action_types acty

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
608: and acty.name in (