DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on AME_ACTION_TYPES

Line 216: from ame_action_types

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

Line 585: ,ame_action_types aty

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

Line 606: ,ame_action_types acty

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