DBA Data[Home] [Help]

APPS.AME_MULTI_TENANCY_PKG dependencies on AME_ACTION_TYPES

Line 837: , ame_action_types act

833: cursor getGrpActionParam(c_action_id in number) is
834: select parameter
835: ,ac.action_type_id
836: from ame_actions ac
837: , ame_action_types act
838: where ac.action_type_id = act.action_type_id
839: and ac.action_id = c_action_id
840: and sysdate between ac.start_date and nvl(ac.end_Date,sysdate)
841: and sysdate between act.start_date and nvl(act.end_Date,sysdate)

Line 911: from ame_action_types act

907: rule_strt_date_chd varchar2(2) := 'N';
908:
909: cursor chkCorrectAction(c_action_id in number,c_rule_type in number) is
910: select 'Y'
911: from ame_action_types act
912: ,ame_actions ac
913: ,ame_action_type_usages actu
914: where ac.action_id = c_action_id
915: and actu.rule_type = c_rule_type