789: l_id NUMBER;
790: BEGIN
791: SELECT activity_id
792: INTO l_id
793: FROM cst_activities
794: WHERE NVL(organization_id, p_organization_id ) = p_organization_id
795: AND activity = p_activity;
796:
797: RETURN l_id;