APPS.OE_ORDER_WF_UTIL dependencies on OE_LOOKUPS

Line 1784: FROM oe_lookups

1780: THEN
1781: -- validate p_flow_status
1782: SELECT lookup_code
1783: INTO l_flow_status_code
1784: FROM oe_lookups
1785: WHERE lookup_type = 'FLOW_STATUS'
1786: AND lookup_code = p_flow_status_code
1787: AND enabled_flag = 'Y'
1788: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)

Line 2079: FROM oe_lookups

2075: THEN
2076: -- validate p_flow_status
2077: SELECT lookup_code
2078: INTO l_flow_status_code
2079: FROM oe_lookups
2080: WHERE lookup_type = 'LINE_FLOW_STATUS'
2081: AND lookup_code = p_flow_status_code
2082: AND enabled_flag = 'Y'
2083: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)

Line 2156: FROM oe_lookups

2152: THEN
2153: -- validate p_flow_status
2154: SELECT lookup_code
2155: INTO l_flow_status_code
2156: FROM oe_lookups
2157: WHERE lookup_type = 'FLOW_STATUS'
2158: AND lookup_code = p_flow_status_code
2159: AND enabled_flag = 'Y'
2160: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)

Line 2946: FROM oe_lookups

2942: THEN
2943: -- if flow_status_code is passed in, validate it
2944: SELECT lookup_code
2945: INTO l_flow_status_code
2946: FROM oe_lookups
2947: WHERE lookup_type = 'FLOW_STATUS'
2948: AND lookup_code = p_flow_status_code
2949: AND enabled_flag = 'Y'
2950: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)

Line 5108: FROM oe_lookups

5104: CLOSE book_deferred;
5105: ELSE
5106: SELECT meaning
5107: INTO l_flow_status
5108: FROM oe_lookups
5109: WHERE lookup_type = 'FLOW_STATUS'
5110: AND lookup_code = l_flow_status_code
5111: AND enabled_flag = 'Y'
5112: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)