APPS.AHL_UC_TREE_PVT dependencies on FND_LOOKUP_VALUES_VL
Line 582: fnd_lookup_values_vl F
578: l_pos_necessity_meaning fnd_lookups.meaning%TYPE;
579: CURSOR get_position_necessity(c_relationship_id NUMBER) IS
580: SELECT F.meaning
581: FROM ahl_mc_relationships A, 582: fnd_lookup_values_vl F 583: WHERE A.relationship_id = c_relationship_id
584: AND A.position_necessity_code = F.lookup_code (+)
585: AND F.lookup_type (+) = 'AHL_POSITION_NECESSITY';
586: BEGIN