APPS.EDR_RULE_TEMP dependencies on AME_RULES_VL

Line 745: FROM AME_RULES_VL AME_RULES,

741: BEGIN
742:
743: SELECT COUNT(*)
744: INTO L_COUNT_NUM
745: FROM AME_RULES_VL AME_RULES,
746: EDR_AMERULE_INPUT_VAR RULE_VAR
747: WHERE AME_RULES.RULE_ID = L_RULE_IDS(ith)
748: AND AME_RULES.RULE_ID = RULE_VAR.RULE_ID
749: AND RULE_VAR.AME_TRANS_ID = P_TRANSACTION_ID

Line 784: INTO L_RULE_NAME FROM AME_RULES_VL

780: EXCEPTION
781: WHEN NO_DATA_FOUND THEN
782:
783: SELECT DISTINCT DESCRIPTION
784: INTO L_RULE_NAME FROM AME_RULES_VL
785: WHERE RULE_ID = L_RULE_IDS(ith) AND (END_DATE IS NULL OR END_DATE > SYSDATE);
786:
787: INSERT INTO EDR_RULE_DETAIL_TEMP ( SESSION_ID, TRANSACTION_TYPE_ID, RULE_ID, RULE_NAME,
788: DEFAULT_VAR, START_DATE, END_DATE)

Line 839: INTO L_RULE_NAME FROM AME_RULES_VL

835: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);
836:
837:
838: SELECT DISTINCT DESCRIPTION
839: INTO L_RULE_NAME FROM AME_RULES_VL
840: WHERE RULE_ID = P_RULE_ID
841: AND SYSDATE <= NVL(END_DATE,SYSDATE);
842:
843: