DBA Data[Home] [Help]

APPS.INVPVDR6 dependencies on MFG_LOOKUPS

Line 50: FROM MFG_LOOKUPS

46: -- Added for bug # 3762750
47: CURSOR c_mfglookup_exists(cp_lookup_type VARCHAR2,
48: cp_lookup_code VARCHAR2) IS
49: SELECT 'x'
50: FROM MFG_LOOKUPS
51: WHERE LOOKUP_TYPE = cp_lookup_type
52: AND LOOKUP_CODE = cp_lookup_code
53: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
54: AND ENABLED_FLAG = 'Y';