DBA Data[Home] [Help]

APPS.AME_AXU_BUS dependencies on AME_ACTION_TYPE_USAGES

Line 109: FROM ame_action_type_usages

105: l_count number;
106: begin
107: SELECT count(action_type_id)
108: INTO l_count
109: FROM ame_action_type_usages
110: WHERE action_type_id = p_action_type_id
111: AND SYSDATE BETWEEN start_date AND
112: nvl(end_date - (1/86400), sysdate);
113: if l_count <> 0 then