DBA Data[Home] [Help]

APPS.AME_API3 dependencies on AME_ACTION_USAGES

Line 1878: ame_action_usages,

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

Line 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

Line 1883: ame_actions.action_id = ame_action_usages.action_id 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

Line 1886: ame_action_usages.start_date 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

Line 1887: nvl(ame_action_usages.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

Line 1951: ame_action_usages,

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

Line 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

Line 1956: ame_actions.action_id = ame_action_usages.action_id 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

Line 1959: ame_action_usages.start_date 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

Line 1960: nvl(ame_action_usages.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

Line 2026: ame_action_usages,

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

Line 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

Line 2031: ame_actions.action_id = ame_action_usages.action_id 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

Line 2034: ame_action_usages.start_date 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

Line 2035: nvl(ame_action_usages.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