DBA Data[Home] [Help]

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