APPS.AME_ATTRIBUTE_USAGES_API dependencies on AME_CONDITION_USAGES

Line 45: AME_CONDITION_USAGES

41: for TEMPRULE in RULE_CURSOR(X_APPLICATION_ID => X_APPLICATION_ID) loop
42: select count(*)
43: into TEMP_COUNT
44: from AME_CONDITIONS,
45: AME_CONDITION_USAGES
46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE

Line 47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID

43: into TEMP_COUNT
44: from AME_CONDITIONS,
45: AME_CONDITION_USAGES
46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE

Line 48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID

44: from AME_CONDITIONS,
45: AME_CONDITION_USAGES
46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))

Line 51: and ((sysdate between AME_CONDITION_USAGES.START_DATE

47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE
54: and AME_CONDITION_USAGES.START_DATE <
55: nvl(AME_CONDITION_USAGES.END_DATE,

Line 52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))

48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE
54: and AME_CONDITION_USAGES.START_DATE <
55: nvl(AME_CONDITION_USAGES.END_DATE,
56: AME_CONDITION_USAGES.START_DATE + (1/86400))));

Line 53: or (sysdate < AME_CONDITION_USAGES.START_DATE

49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE
54: and AME_CONDITION_USAGES.START_DATE <
55: nvl(AME_CONDITION_USAGES.END_DATE,
56: AME_CONDITION_USAGES.START_DATE + (1/86400))));
57: if(TEMP_COUNT > 0) then

Line 54: and AME_CONDITION_USAGES.START_DATE <

50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE
54: and AME_CONDITION_USAGES.START_DATE <
55: nvl(AME_CONDITION_USAGES.END_DATE,
56: AME_CONDITION_USAGES.START_DATE + (1/86400))));
57: if(TEMP_COUNT > 0) then
58: NEW_USE_COUNT := NEW_USE_COUNT + 1;

Line 55: nvl(AME_CONDITION_USAGES.END_DATE,

51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE
54: and AME_CONDITION_USAGES.START_DATE <
55: nvl(AME_CONDITION_USAGES.END_DATE,
56: AME_CONDITION_USAGES.START_DATE + (1/86400))));
57: if(TEMP_COUNT > 0) then
58: NEW_USE_COUNT := NEW_USE_COUNT + 1;
59: else

Line 56: AME_CONDITION_USAGES.START_DATE + (1/86400))));

52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE
54: and AME_CONDITION_USAGES.START_DATE <
55: nvl(AME_CONDITION_USAGES.END_DATE,
56: AME_CONDITION_USAGES.START_DATE + (1/86400))));
57: if(TEMP_COUNT > 0) then
58: NEW_USE_COUNT := NEW_USE_COUNT + 1;
59: else
60: if TEMPRULE.ACTION_ID is null then