[Home] [Help]
965: BEGIN
966: -- get policy name
967: SELECT name
968: INTO x_policy_name
969: FROM pa_ego_phases_v
970: WHERE proj_element_id = l_current_phase_id;
971: IF p_inventory_item_id IS NOT NULL THEN
972: -- get concatenated segments
973: SELECT concatenated_segments