DBA Data[Home] [Help]

APPS.WPS_COMMON dependencies on MFG_LOOKUPS

Line 1359: FROM MFG_LOOKUPS

1355: ) IS
1356:
1357: CURSOR c_dir IS
1358: SELECT MEANING
1359: FROM MFG_LOOKUPS
1360: WHERE LOOKUP_TYPE = 'WIP_SCHED_DIRECTION'
1361: AND ENABLED_FLAG = 'Y'
1362: AND sysdate BETWEEN
1363: NVL(START_DATE_ACTIVE, sysdate-1) AND NVL(END_DATE_ACTIVE, sysdate + 1)

Line 1369: FROM MFG_LOOKUPS

1365: ORDER BY LOOKUP_CODE;
1366:
1367: CURSOR c_yesno IS
1368: SELECT MEANING
1369: FROM MFG_LOOKUPS
1370: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
1371: AND ENABLED_FLAG = 'Y'
1372: AND sysdate BETWEEN
1373: NVL(START_DATE_ACTIVE, sysdate-1) AND NVL(END_DATE_ACTIVE, sysdate + 1)