1874: ame_action_types.name,
1875: ame_action_types.description,
1876: ame_actions.description
1877: from
1878: ame_action_usages,
1879: ame_action_types,
1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1878: ame_action_usages,
1879: ame_action_types,
1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and
1885: sysdate between
1886: ame_action_usages.start_date and
1879: ame_action_types,
1880: ame_actions
1881: where
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and
1885: sysdate between
1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1882: ame_action_usages.rule_id = ruleIdIn and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and
1885: sysdate between
1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1888: sysdate between
1889: ame_action_types.start_date and
1890: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1883: ame_actions.action_id = ame_action_usages.action_id and
1884: ame_action_types.action_type_id = ame_actions.action_type_id and
1885: sysdate between
1886: ame_action_usages.start_date and
1887: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1888: sysdate between
1889: ame_action_types.start_date and
1890: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1891: sysdate between
1947: ame_action_types.name,
1948: ame_action_types.description,
1949: ame_actions.description
1950: from
1951: ame_action_usages,
1952: ame_action_types,
1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1951: ame_action_usages,
1952: ame_action_types,
1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and
1958: sysdate between
1959: ame_action_usages.start_date and
1952: ame_action_types,
1953: ame_actions
1954: where
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and
1958: sysdate between
1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1955: ame_action_usages.rule_id = ruleIdIn and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and
1958: sysdate between
1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1961: sysdate between
1962: ame_action_types.start_date and
1963: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1956: ame_actions.action_id = ame_action_usages.action_id and
1957: ame_action_types.action_type_id = ame_actions.action_type_id and
1958: sysdate between
1959: ame_action_usages.start_date and
1960: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1961: sysdate between
1962: ame_action_types.start_date and
1963: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1964: sysdate between
2022: ame_action_types.name,
2023: ame_action_types.description,
2024: ame_actions.description
2025: from
2026: ame_action_usages,
2027: ame_action_types,
2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2026: ame_action_usages,
2027: ame_action_types,
2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and
2033: sysdate between
2034: ame_action_usages.start_date and
2027: ame_action_types,
2028: ame_actions
2029: where
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and
2033: sysdate between
2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2030: ame_action_usages.rule_id = ruleIdIn and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and
2033: sysdate between
2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2036: sysdate between
2037: ame_action_types.start_date and
2038: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2031: ame_actions.action_id = ame_action_usages.action_id and
2032: ame_action_types.action_type_id = ame_actions.action_type_id and
2033: sysdate between
2034: ame_action_usages.start_date and
2035: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2036: sysdate between
2037: ame_action_types.start_date and
2038: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2039: sysdate between