eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_CONDITION_PKG dependencies on AME_CALLING_APPS

Line 1955: select distinct ame_calling_apps.application_name

1951: applicationNamesOut out nocopy ame_util.stringList) as
1952: upperLimit integer;
1953: cursor getApplicationsCursor(conditionIdIn in integer,
1954: applicationIdIn in integer) is
1955: select distinct ame_calling_apps.application_name
1956: from
1957: ame_rules,
1958: ame_rule_usages,
1959: ame_calling_apps,

Line 1959: ame_calling_apps,

1955: select distinct ame_calling_apps.application_name
1956: from
1957: ame_rules,
1958: ame_rule_usages,
1959: ame_calling_apps,
1960: ame_condition_usages
1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and
1963: ame_rules.rule_id = ame_condition_usages.rule_id and

Line 1964: ame_rule_usages.item_id = ame_calling_apps.application_id and

1960: ame_condition_usages
1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and
1963: ame_rules.rule_id = ame_condition_usages.rule_id and
1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or

Line 1982: sysdate between ame_calling_apps.start_date and

1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and
1982: sysdate between ame_calling_apps.start_date and
1983: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
1984: order by ame_calling_apps.application_name;
1985: tempIndex integer;
1986: begin

Line 1983: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)

1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and
1982: sysdate between ame_calling_apps.start_date and
1983: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
1984: order by ame_calling_apps.application_name;
1985: tempIndex integer;
1986: begin
1987: tempIndex := 1;

Line 1984: order by ame_calling_apps.application_name;

1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and
1982: sysdate between ame_calling_apps.start_date and
1983: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
1984: order by ame_calling_apps.application_name;
1985: tempIndex integer;
1986: begin
1987: tempIndex := 1;
1988: for getApplicationsRec in getApplicationsCursor(conditionIdIn => conditionIdIn,