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 1958: select distinct ame_calling_apps.application_name

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

Line 1962: ame_calling_apps,

1958: select distinct ame_calling_apps.application_name
1959: from
1960: ame_rules,
1961: ame_rule_usages,
1962: ame_calling_apps,
1963: ame_condition_usages
1964: where
1965: ame_rules.rule_id = ame_rule_usages.rule_id and
1966: ame_rules.rule_id = ame_condition_usages.rule_id and

Line 1967: ame_rule_usages.item_id = ame_calling_apps.application_id and

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

Line 1985: sysdate between ame_calling_apps.start_date and

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

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

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

Line 1987: order by ame_calling_apps.application_name;

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