DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 596: fnd_lookup_values_vl F

592: l_pos_necessity_meaning fnd_lookups.meaning%TYPE;
593: CURSOR get_position_necessity(c_relationship_id NUMBER) IS
594: SELECT F.meaning
595: FROM ahl_mc_relationships A,
596: fnd_lookup_values_vl F
597: WHERE A.relationship_id = c_relationship_id
598: AND A.position_necessity_code = F.lookup_code (+)
599: AND F.lookup_type (+) = 'AHL_POSITION_NECESSITY';
600: BEGIN