APPS.OE_ERROR_WF dependencies on OE_LOOKUPS

Line 109: FROM oe_lookups

105:
106: IF l_flow_status_code is not NULL THEN
107: SELECT MEANING
108: INTO l_flow_status_code_meaning
109: FROM oe_lookups
110: where LOOKUP_CODE = l_flow_status_code
111: AND LOOKUP_TYPE = 'FLOW_STATUS';
112: END IF;
113:

Line 512: FROM oe_lookups

508:
509: IF l_flow_status_code is not NULL THEN
510: SELECT MEANING
511: INTO l_flow_status_code_meaning
512: FROM oe_lookups
513: where LOOKUP_CODE = l_flow_status_code
514: AND LOOKUP_TYPE = 'FLOW_STATUS';
515: END IF;
516:

Line 615: FROM oe_lookups

611:
612: IF l_flow_status_code is not NULL then
613: SELECT MEANING
614: INTO l_flow_status_code_meaning
615: FROM oe_lookups
616: where LOOKUP_CODE = l_flow_status_code
617: AND LOOKUP_TYPE = 'LINE_FLOW_STATUS';
618: END IF;
619:

Line 756: FROM oe_lookups

752:
753: BEGIN
754: SELECT MEANING
755: INTO l_flow_status_code_meaning
756: FROM oe_lookups
757: where LOOKUP_CODE = l_flow_status_code
758: AND LOOKUP_TYPE = 'FLOW_STATUS';
759: EXCEPTION WHEN OTHERS THEN
760: l_flow_status_code_meaning := NULL;

Line 2488: FROM OE_LOOKUPS

2484:
2485: end if;
2486:
2487: SELECT MEANING into l_user_mode
2488: FROM OE_LOOKUPS
2489: WHERE LOOKUP_CODE= p_mode
2490: AND LOOKUP_TYPE='ONT_RETRY_MODE'
2491: AND ENABLED_FLAG='Y'
2492: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);