APPS.OE_ORDER_WF_UTIL dependencies on OE_LOOKUPS

Line 1522: FROM oe_lookups

1518: IF p_header_id IS NOT NULL THEN
1519: -- validate p_flow_status
1520: SELECT lookup_code
1521: INTO l_flow_status_code
1522: FROM oe_lookups
1523: WHERE lookup_type= 'FLOW_STATUS'
1524: AND lookup_code = p_flow_status_code
1525: AND enabled_flag = 'Y'
1526: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1739: FROM oe_lookups

1735: -- validate p_flow_status
1736:
1737: SELECT lookup_code
1738: INTO l_flow_status_code
1739: FROM oe_lookups
1740: WHERE lookup_type = 'LINE_FLOW_STATUS'
1741: AND lookup_code = p_flow_status_code
1742: AND enabled_flag = 'Y'
1743: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1823: FROM oe_lookups

1819: -- validate p_flow_status
1820:
1821: SELECT lookup_code
1822: INTO l_flow_status_code
1823: FROM oe_lookups
1824: WHERE lookup_type = 'FLOW_STATUS'
1825: AND lookup_code = p_flow_status_code
1826: AND enabled_flag = 'Y'
1827: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 2336: FROM oe_lookups

2332: IF p_flow_status_code is not null THEN
2333: -- if flow_status_code is passed in, validate it
2334: SELECT lookup_code
2335: INTO l_flow_status_code
2336: FROM oe_lookups
2337: WHERE lookup_type= 'FLOW_STATUS'
2338: AND lookup_code = p_flow_status_code
2339: AND enabled_flag = 'Y'
2340: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 3920: from oe_lookups

3916: CLOSE book_deferred;
3917: ELSE
3918: select MEANING
3919: into l_flow_status
3920: from oe_lookups
3921: WHERE lookup_type= 'FLOW_STATUS'
3922: AND lookup_code = l_flow_status_code
3923: AND enabled_flag = 'Y'
3924: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)