DBA Data[Home] [Help]

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)