APPS.PV_COMMON_CHECKS_PVT dependencies on FND_LOOKUP_VALUES
Line 131: FROM fnd_lookup_values
127: )
128: IS
129: CURSOR C_Lookup_Exists (C_Lookup_Code VARCHAR2, C_Lookup_Type VARCHAR2) IS
130: SELECT 'X' 131: FROM fnd_lookup_values 132: WHERE lookup_type = C_Lookup_Type
133: AND lookup_code = C_Lookup_Code
134: AND enabled_flag = 'Y'
135: AND (start_date_active IS NULL OR start_date_active < SYSDATE)