DBA Data[Home] [Help]

APPS.AME_API3 dependencies on AME_ACTION_USAGES

Line 1721: ame_action_usages,

1717: ame_action_types.name,
1718: ame_action_types.description,
1719: ame_actions.description
1720: from
1721: ame_action_usages,
1722: ame_action_types,
1723: ame_actions
1724: where
1725: ame_action_usages.rule_id = ruleIdIn and

Line 1725: ame_action_usages.rule_id = ruleIdIn and

1721: ame_action_usages,
1722: ame_action_types,
1723: ame_actions
1724: where
1725: ame_action_usages.rule_id = ruleIdIn and
1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and
1728: sysdate between
1729: ame_action_usages.start_date and

Line 1726: ame_actions.action_id = ame_action_usages.action_id and

1722: ame_action_types,
1723: ame_actions
1724: where
1725: ame_action_usages.rule_id = ruleIdIn and
1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and
1728: sysdate between
1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1729: ame_action_usages.start_date and

1725: ame_action_usages.rule_id = ruleIdIn and
1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and
1728: sysdate between
1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1731: sysdate between
1732: ame_action_types.start_date and
1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and
1728: sysdate between
1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1731: sysdate between
1732: ame_action_types.start_date and
1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1734: sysdate between

Line 1794: ame_action_usages,

1790: ame_action_types.name,
1791: ame_action_types.description,
1792: ame_actions.description
1793: from
1794: ame_action_usages,
1795: ame_action_types,
1796: ame_actions
1797: where
1798: ame_action_usages.rule_id = ruleIdIn and

Line 1798: ame_action_usages.rule_id = ruleIdIn and

1794: ame_action_usages,
1795: ame_action_types,
1796: ame_actions
1797: where
1798: ame_action_usages.rule_id = ruleIdIn and
1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and
1801: sysdate between
1802: ame_action_usages.start_date and

Line 1799: ame_actions.action_id = ame_action_usages.action_id and

1795: ame_action_types,
1796: ame_actions
1797: where
1798: ame_action_usages.rule_id = ruleIdIn and
1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and
1801: sysdate between
1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1802: ame_action_usages.start_date and

1798: ame_action_usages.rule_id = ruleIdIn and
1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and
1801: sysdate between
1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1804: sysdate between
1805: ame_action_types.start_date and
1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and
1801: sysdate between
1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1804: sysdate between
1805: ame_action_types.start_date and
1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1807: sysdate between

Line 1869: ame_action_usages,

1865: ame_action_types.name,
1866: ame_action_types.description,
1867: ame_actions.description
1868: from
1869: ame_action_usages,
1870: ame_action_types,
1871: ame_actions
1872: where
1873: ame_action_usages.rule_id = ruleIdIn and

Line 1873: ame_action_usages.rule_id = ruleIdIn and

1869: ame_action_usages,
1870: ame_action_types,
1871: ame_actions
1872: where
1873: ame_action_usages.rule_id = ruleIdIn and
1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and
1876: sysdate between
1877: ame_action_usages.start_date and

Line 1874: ame_actions.action_id = ame_action_usages.action_id and

1870: ame_action_types,
1871: ame_actions
1872: where
1873: ame_action_usages.rule_id = ruleIdIn and
1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and
1876: sysdate between
1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

Line 1877: ame_action_usages.start_date and

1873: ame_action_usages.rule_id = ruleIdIn and
1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and
1876: sysdate between
1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1879: sysdate between
1880: ame_action_types.start_date and
1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and
1876: sysdate between
1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1879: sysdate between
1880: ame_action_types.start_date and
1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1882: sysdate between