DBA Data[Home] [Help]

APPS.AME_ACF_BUS dependencies on AME_ACTION_TYPE_USAGES

Line 296: FROM ame_action_type_usages

292: l_rule_type number;
293: begin
294: SELECT rule_type
295: INTO l_rule_type
296: FROM ame_action_type_usages
297: WHERE action_type_id = p_action_type_id
298: AND SYSDATE BETWEEN start_date and
299: nvl(end_date - (1/86400), sysdate)
300: AND ROWNUM < 2;

Line 363: FROM ame_action_type_usages

359: l_rule_type number;
360: begin
361: SELECT rule_type
362: INTO l_rule_type
363: FROM ame_action_type_usages
364: WHERE action_type_id = p_action_type_id
365: AND SYSDATE BETWEEN start_date and
366: nvl(end_date - (1/86400), sysdate)
367: AND ROWNUM < 2;