APPS.EDR_RULE_TEMP dependencies on AME_CALLING_APPS_VL

Line 727: FROM AME_CALLING_APPS_VL

723: SELECT USERENV('SESSIONID') INTO L_SSNID FROM DUAL;
724:
725: --Obtain the application ID and application Name from the AME tables.
726: SELECT DISTINCT APPLICATION_ID, APPLICATION_NAME INTO L_APPS_ID, L_APPS_NAME
727: FROM AME_CALLING_APPS_VL
728: WHERE TRANSACTION_TYPE_ID = P_TRANSACTION_ID
729: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
730:
731: --Obtain all the applicable AME rules in one shot.

Line 833: FROM AME_CALLING_APPS_VL

829:
830: SELECT USERENV('SESSIONID') INTO L_SSNID FROM DUAL;
831:
832: SELECT APPLICATION_ID INTO L_APPS_ID
833: FROM AME_CALLING_APPS_VL
834: WHERE TRANSACTION_TYPE_ID = P_TRANSACTION_ID
835: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
836:
837:

Line 920: FROM AME_CALLING_APPS_VL AME_APPS,

916:
917: DELETE FROM EDR_AMERULE_INPUT_VAR RULE_VAR
918: WHERE RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID
919: AND RULE_VAR.RULE_ID NOT IN (SELECT AME_USAGES.RULE_ID
920: FROM AME_CALLING_APPS_VL AME_APPS,
921: AME_RULE_USAGES AME_USAGES
922: WHERE AME_APPS.TRANSACTION_TYPE_ID = P_TRANSACTION_ID
923: AND AME_APPS.APPLICATION_ID = AME_USAGES.ITEM_ID
924: AND SYSDATE <= NVL(AME_USAGES.END_DATE,SYSDATE));

Line 956: FROM AME_CALLING_APPS_VL AME_APPS,

952:
953: SELECT COUNT(*) INTO L_COUNT FROM EDR_AMERULE_INPUT_VAR RULE_VAR
954: WHERE RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID
955: AND RULE_VAR.RULE_ID NOT IN (SELECT AME_USAGES.RULE_ID
956: FROM AME_CALLING_APPS_VL AME_APPS,
957: AME_RULE_USAGES AME_USAGES
958: WHERE AME_APPS.TRANSACTION_TYPE_ID = P_TRANSACTION_ID
959: AND AME_APPS.APPLICATION_ID = AME_USAGES.ITEM_ID
960: AND SYSDATE <= NVL(AME_USAGES.END_DATE,SYSDATE));