337: --===================================================================== */
338: PROCEDURE get_activity_desc(p_activity IN VARCHAR2, p_activity_desc OUT NOCOPY VARCHAR2) IS
339: CURSOR get_activity_desc IS
340: SELECT activity_desc 341: FROM fm_actv_mst 342: where activity = p_activity;
343: BEGIN
344: open get_activity_desc;
345: fetch get_activity_desc INTO p_activity_desc;