DBA Data[Home] [Help]

APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 136: FROM fnd_lookup_values_vl

132:
133: CURSOR fnd_lookup_csr (p_lookup_type IN VARCHAR2,
134: p_lookup_meaning IN VARCHAR2) IS
135: SELECT lookup_code
136: FROM fnd_lookup_values_vl
137: WHERE lookup_type = p_lookup_type
138: AND meaning = p_lookup_meaning
139: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
140: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));

Line 313: FROM fnd_lookup_values_vl

309:
310: Cursor Serial_Tag_Mean_Cur(c_lookup_code IN VARCHAR2)
311: IS
312: SELECT meaning
313: FROM fnd_lookup_values_vl
314: WHERE lookup_type = 'AHL_SERIALNUMBER_TAG'
315: AND lookup_code = c_lookup_code;
316:
317: l_attribute_code VARCHAR2(30);